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:
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.