Sum If on muliple conditions

Better options:

[A]

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

[B]

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

[C]

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

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" <FrankTimJr@discussions.microsoft.com> wrote in message
> news:9A71CE9F-AC3F-4DB7-8F82-C5133E8310A8@microsoft.com...
>
>>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.

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

Hi!

Try this:

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

Biff

"FrankTimJr" <FrankTimJr@discussions.microsoft.com> wrote in message
news:9A71CE9F-AC3F-4DB7-8F82-C5133E8310A8@microsoft.com...
>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:H10)))

-sk

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:H10)

[C]

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

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" <FrankTimJr@discussions.microsoft.com> wrote in message
> news:9A71CE9F-AC3F-4DB7-8F82-C5133E8310A8@microsoft.com...
>
>>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.

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

Hi!

Try this:

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

Biff

"FrankTimJr" <FrankTimJr@discussions.microsoft.com> wrote in message
news:9A71CE9F-AC3F-4DB7-8F82-C5133E8310A8@microsoft.com...
>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:H10)))

-sk

Hi!

Try this:

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

Biff

"FrankTimJr" <FrankTimJr@discussions.microsoft.com> wrote in message
news:9A71CE9F-AC3F-4DB7-8F82-C5133E8310A8@microsoft.com...
>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.
>
>

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

-sk

Better options:

[A]

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

[B]

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

[C]

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

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" <FrankTimJr@discussions.microsoft.com> wrote in message
> news:9A71CE9F-AC3F-4DB7-8F82-C5133E8310A8@microsoft.com...
>
>>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.

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:H10)))

-sk

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.

Hi!

Try this:

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

Biff

"FrankTimJr" <FrankTimJr@discussions.microsoft.com> wrote in message
news:9A71CE9F-AC3F-4DB7-8F82-C5133E8310A8@microsoft.com...
>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:H10)

[C]

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

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" <FrankTimJr@discussions.microsoft.com> wrote in message
> news:9A71CE9F-AC3F-4DB7-8F82-C5133E8310A8@microsoft.com...
>
>>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.

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:H10)

[C]

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

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" <FrankTimJr@discussions.microsoft.com> wrote in message
> news:9A71CE9F-AC3F-4DB7-8F82-C5133E8310A8@microsoft.com...
>
>>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.