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.

Try
SUMPRODUCT((SUMIF(G3:G10,{"Jul","Aug","Sep"},B355: B364)))

-sk

FrankTimJr wrote:
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.

Try
SUMPRODUCT((SUMIF(G3:G10,{"Jul","Aug","Sep"},H3:H1 0)))

-sk

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.

Sweet! Thanks a million!

"sk" wrote:

Try
SUMPRODUCT((SUMIF(G3:G10,{"Jul","Aug","Sep"},B355: B364)))

-sk

FrankTimJr wrote:
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))

[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.