SUMIF with multiple criteria

[Anne Troy]

I never seem to get this right...or did they change the formula?

I want to change the following formula to sum ONLY IF there is an "A" in column A.

="MST Ob: $"&SUMIF(B4:B155,"MST",H4:H155)

I hope that someday this comes as second nature like many other formulas, but to me vlookup was much easier. I don't understand the sumproducts and the hyphens...

 

[Roo007]

Thank you VERY much!

 

[Roo007]

will the same formula in post 16 work for a COUNTIFS? Instead of suming column D, it would count the number of times that same criteria in post 16 was met! 3 being the result/answer. Could you tell me the formula to make that work.
The formula in post 16: ((A2:A10<>F4)*(B2:B10&C2:C10<>F4&G4)*(D2:D10))

 

[jtakw]

will the same formula in post 16 work for a COUNTIFS? Instead of suming column D, it would count the number of times that same criteria in post 16 was met! 3 being the result/answer. Could you tell me the formula to make that work.
The formula in post 16: ((A2:A10<>F4)*(B2:B10&C2:C10<>F4&G4)*(D2:D10))

Don't you mean that the answer would be 4?

=SUMPRODUCT((A2:A10<>F4)*(B2:B10&C2:C10<>F4&G4))

 

[Roo007]

Yes, answer solved. Thank you all!

 

[jtakw]

You're welcome.