Using SumProduct to add values

[Edge118]

I have the following data


Column A: Date
Column B: Module Name
Column C: Numeric Value

The question I have is: Lets say that I want to use a formula in cel
D3 that adds all the values in column C that have date equal to may
and in column B module name equal to "Test". I've using SumProduct t
get the total number of rows that meet my criteria, but is there a wa
I can add the actual values together?

Thanks for your help!


R

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A100=DATE(2004,5,3)),--(B1:B100="Test"),C1:C100)