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!!
Bookmarks