I am having difficulty with a countif formula, specifically a cell reference within the equation.
The solution is correct (121) with this formula:
But is incorrect (zero) with this formula:HTML Code:
Cell K79 isHTML Code:I would really like to use a cell reference within the equation then I can drag the same formula down many rows, without having to type in the unique date at the end of each equation each time. What should I change?HTML Code:
Bookmarks