I'm trying to figure yet another formula here. I'm trying to do the following:

I want to sum up the numbers of column C, provided that column AA has a specific date value of "8-Oct-2010" and also has a value of "Y" in column B.

or said another way:

If one column (AA) from my 'Data' sheet has a date value in it (ex. 8-Oct-2010) and another column (B) has a value of "Y", then I want to sum up the numbers of column (C), which pertain to that specific date of 8-Oct-2010 and which also have a value of "Y" in column (B)

So...I tried the following formula:


=SUMPRODUCT((Data!$AA$2:$AA$100=$A$1)*(Data!$B$2:$B$100="Y")*(Data!$C$2:$C$100))

(Where A1 contains the date I want to match)


BUT...it keeps returning a 0 value!....Any help please!!