I have a large survey that I'm attempting to organize results from. I can't get my array formula to work. I'm using Excel 07.
Here is the formula. I have also attached a sample worksheet.
The formula returns a count of the total results, not the total based on the criteria. I've attempted to use the COUNT function as well, but felt it was not effective, plus the result is 0.![]()
{=COUNTA(IF((($F$4:$F$13="Y"))*($L$4:$L$13=C2),$E$4:$E$13))}
Please help
Bookmarks