SUMPRODUCT across worksheet not working

Originally Posted by NBVC

So you tried this... and it doesn't work?

=SUMPRODUCT(--(Test!C:C="Online Giving - Website"),--(Test!A:A>=DATE(2010,1,1)),--(Test!A:A<=DATE(2010,3,31)),Test!B:B)

Thank you so much! I should have caught that one...