Hi folks,
I am trying to use the following formula to count the number of "W" values in a range - simple example below.
=COUNTIF('Raw Data'!C55:C57,"W")
But i want to C57 part of the range to be dynamic, based on a header date.
Basically i want to the range to be built like this - the MATCH formula below returns a row number; say 57.
CONCATENATE("'Raw Data'!C55:", "C", MATCH(D5,'Raw Data'!$B:$B,0))
So I am using the following formula to get it.
=COUNTIF(CONCATENATE("'Raw Data'!C55:", "C", MATCH(D5,'Raw Data'!$B:$B,0)),"W")
But i keep getting "We found a problem with this formula" error.
For info the following formula succesffuly returns 'Raw Data'!C55:C57
=CONCATENATE("'Raw Data'!C55:", "C", MATCH(F5,'Raw Data'!$B:$B,0))
So it seems to be the connect with the Countif formula.
Am i doing something wrong with the syntax?
Thanks in advance.
Bookmarks