SUMIF with OR conditions

[Donr]

SUMIF(A:A,OR("=CRANE", "=EXCAVATOR", "=BOAT"),H:H)

I'm trying to sum field H only if field A = CRANE, EXCAVATOR, BOAT. I don't think I have the OR in the correct place and I have tried several varaions without much luck (keep getting 0) - can somebody help?

Thank You!

[HansV]

Try this version:

=SUM(SUMIF(A:A,{"CRANE","EXCAVATOR","BOAT"},H:H))

[Donr]

PERFECT! Do the curly brackets act like an OR statement?

[HansV]

More or less. The curly brackets define an array.
SUMIF(A:A,{"CRANE","EXCAVATOR","BOAT"},H:H) results in 3 separate sums: one for "CRANE", another for "EXCAVATOR" and a third one for "BOAT". The enclosing SUM(...) adds those three together.

[Donr]

Great to know - thank you for your help!!!!!!

[Donr]

I'm still working with this formula and I've run across another question.

Given the example above =SUM(SUMIF(A:A,{"CRANE","EXCAVATOR","BOAT"},H:H)), I want to add another condition to this to only sum records where column B:B = Y. I've tried several placements of OR and tried SUMIFS, and I can't get the correct order. Can you help?

[HansV]

Try this formula:

=SUM(SUMIFS(H:H,A:A,{"CRANE","EXCAVATOR","BOAT"},B:B,"Y"))

SUMIFS has a different syntax than SUMIF: the sum range must be specified first, then the condition range - condition pairs.

[Donr]

Worked like a charm!! thanks again!