I've been trying the different suggestions in the postings here and have not
been successful.

I have the following information
Initials Name Value
MM CC 2
JW ee 2
MM BB 3

In column D I would like to get the values based on the criteria. For
example if Row A1=mm add the value that is in C1 and if B1=ee add the value.

I have tried the following: =SUM(IF((A3:A6="mm")*(B3:B6="e"),C3:C6)) it
returns a Zero (0). Have also tried the product and get an error. Not sure
if I can actually do this?

I would appreciate any help you can provide!!