Using SumProduct to add values

E

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
 
Top