Survey Results Array Formula

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.

Please Login or Register  to view this content.

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.

Please help

XL2007 has COUNTIFS and SUMIFS functions.. have a look at them.

=COUNTIFS($F$4:$F$13,"Y",$L$4:$L$13,C2)

and

=SUMIFS($E$4:$E$13,$F$4:$F$13,"Y",$L$4:$L$13,C2)


For what you appear to be doing in the attachment, I think you need something more like:

=SUMPRODUCT(($C$13:$H$13=$B3)*($I$14:$I$23=C$2)*($C$14:$H$23="Y"))

copied down and to next column.