Greetings,
I have a spreadsheet with a tab "Data" that looks like this:
A B C D
System ID Date Amt Category
151398 1/1/08 10.00 Online - Website
151398 1/1/08 90.00 Online - Website
151399 1/1/08 30.00 Online - Website
How can I modify the following function to only count the following as 2 gifts (considering two of them have the same system ID)?
=SUMPRODUCT(--(Data!$C:$C= "Online Giving - Website"),--(Data!$A:$A>DATE(2008,1,1)),--(Data!$A:$A<=DATE(2008,1,31)))
If someone can help me out, as you have done so graciously before, that would be awesome. Otherwise I may severely SOL.
Thanks as always,
Bryce
Bookmarks