SumIF

[Guest]

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!!

 

[Guest]

Are you commiting the formula with CTRL+SHIFT+ENTER (it is an array formula)?

Also, is this just a typo: You have a value of "ee" in column B, but in
your formula you are just checking for "e". If it wasn't just a typo in the
post you have to change to match exactly. Or do something like so:

=SUM(IF((A3:A6="mm")*(LEFT(B3:B6)="e"),C3:C6))