I would like to count the number of occurrences of a value in one sheet based on the value of a cell in another sheet.
I would like to use this formula:
COUNTIF(Sheet1!$A$2:$B:130, =A1)
Where A1 on this sheet holds the value that I want to look for and count in Sheet1. Of course that doesn't work. I can make it work by replacing =A1
with "=<the value that is in A1>" but there will be many COUNTIF()
cells and I would rather not have to edit each to match the contents of the criterion cell.