multiple countifs...help!

[step_one]

Hello

Im having some trouble with implemeting multiple countifs scenarios.

I need to count the # of voices for
a) city
b) by invoice type (purge)
c) year (2010)

i used this formula buts giving me zero
=SUM(('Count - Invoice'!$F$1:$AW$1=$C$4)*('Count - Invoice'!$B$3:$B$25=$B6)*('Count - Invoice'!$D$3:$D$25="Purge")*('Count - Invoice'!$F$3:$AW$25))

can someone pls help!

i have attached a sample, and highlighted in red the cell!!! ive been struggling on this for the past hour+

thx u so much!

[teylyn]

Hello,

the value in C4 is a number, but the values in row1 of the other sheets are text. Change the formula for row 1 in the source sheet to

=RIGHT(F2,4)+0

so the result is a number. Copy across. Now your formulas produce a result.

[bebo021999]

Try this, row 1 for year value is no need.

Please Login or Register  to view this content.