Sum If on muliple conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I couldn't find the answer in this newsgroup...Is it possible to get the
Sumif statement to calcluate against three different criteria w/out creating
multiple sumif statements?

Ex: =SUMIF(G3:G10, "Jul", "Aug", Sep", H3:H10)?

I know using the comma's in between the Months, but is there some other way
to get this working? I can't use > or < because the Month's are text only.
 
Better options:

[A]

=SUM(SUMIF(G3:G10,{"Jul","Aug","Sep"}),H3:H10))



=SUMPRODUCT(--ISNUMBER(MATCH(G3:G10,{"Jul","Aug","Sep"},0)),H3:H10)

[C]

=SUMPRODUCT(SUMIF(G3:G10,{"Jul","Aug","Sep"},H3:H10))

Invoke or [C] when you have {"Jul","Aug","Sep"} in some range, say
X1:X3 which is then substituted for the {"Jul","Aug","Sep"} bit in these
formula schemes.
Hi!

Try this:

=SUMPRODUCT((G3:G10={"Jul","Aug","Sep"})*H3:H10)

Biff
Click to expand...

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.
 
Back
Top