SumProduct

[yosemite3]

Hi,

I am trying to us SUMPRODUCT in one worksheet to count instances in another worksheet. I want it to tell me how many cells in column A have a date of 9/1/2011 which also has a U in column C in the same row. Here is the formula I am using but it is not working.

=SUMPRODUCT('September 2011'!A:A,DATE(2011,9,1),'September 2011'!C:C="U")


Any suggestions?

Thank you!

Yosemite

[daddylonglegs]

You can't use whole columns in SUMPRODUCT in Excel 2003.....plus you need some "coercion", try something like this

=SUMPRODUCT(('September 2011'!A1:A1000=DATE(2011,9,1))+0,('September 2011'!C1:C1000="U")+0)

extend ranges as required

[yosemite3]

That did it. Thank you very much!!