Better options:
[A]
=SUM(SUMIF(G3:G10,{"Jul","Aug","Sep"}),H3:H10))
[b]
=SUMPRODUCT(--ISNUMBER(MATCH(G3:G10,{"Jul","Aug","Sep"},0)),H3:H 10)
[C]
=SUMPRODUCT(SUMIF(G3:G10,{"Jul","Aug","Sep"},H3:H1 0))
Invoke [b] 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.
Biff wrote:
Hi!
Try this:
=SUMPRODUCT((G3:G10={"Jul","Aug","Sep"})*H3:H10)
Biff
"FrankTimJr" wrote in message
...
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.
--
[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.
|