Prev: Re Try This
Next: Return Value from a Range (depends on input to determind month
From: parls on 31 Mar 2010 10:06
I've been trying to figure this out on my own based on other similar posts
but I think I just don't understand array formulas. Anyway... I want to sum a
range of cells if 1 of 2 possible criteria are met within a different range
of cells.
Example:
RowA RowB RowC
Col1 P S W
Col2 4 2 1

Sumif(A1:C1,"P" OR "S", A2:C2)

It's the OR that I can't figure out.

Thanks a Bunch!
From: Bob Phillips on 31 Mar 2010 10:10
Try

=SUMPRODUCT((A1:C1={P",S"})*(A2:C2))


--

HTH

Bob

"parls" <parls(a)discussions.microsoft.com> wrote in message
news:FB61B06F-73E4-4E43-9EBB-A9B03F67EACA(a)microsoft.com...
> I've been trying to figure this out on my own based on other similar posts
> but I think I just don't understand array formulas. Anyway... I want to
> sum a
> range of cells if 1 of 2 possible criteria are met within a different
> range
> of cells.
> Example:
> RowA RowB RowC
> Col1 P S W
> Col2 4 2 1
>
> Sumif(A1:C1,"P" OR "S", A2:C2)
>
> It's the OR that I can't figure out.
>
> Thanks a Bunch!


From: Don Guillett on 31 Mar 2010 10:13
Sumproduct((A1:C1={"P","S")*A2:C2)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"parls" <parls(a)discussions.microsoft.com> wrote in message
news:FB61B06F-73E4-4E43-9EBB-A9B03F67EACA(a)microsoft.com...
> I've been trying to figure this out on my own based on other similar posts
> but I think I just don't understand array formulas. Anyway... I want to
> sum a
> range of cells if 1 of 2 possible criteria are met within a different
> range
> of cells.
> Example:
> RowA RowB RowC
> Col1 P S W
> Col2 4 2 1
>
> >
> It's the OR that I can't figure out.
>
> Thanks a Bunch!

From: Don Guillett on 31 Mar 2010 10:16

Oops
) should have been }
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Don Guillett" <dguillett1(a)gmail.com> wrote in message
news:euEfMxN0KHA.6108(a)TK2MSFTNGP06.phx.gbl...
> Sumproduct((A1:C1={"P","S")*A2:C2)
>
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguillett(a)gmail.com
> "parls" <parls(a)discussions.microsoft.com> wrote in message
> news:FB61B06F-73E4-4E43-9EBB-A9B03F67EACA(a)microsoft.com...
>> I've been trying to figure this out on my own based on other similar
>> posts
>> but I think I just don't understand array formulas. Anyway... I want to
>> sum a
>> range of cells if 1 of 2 possible criteria are met within a different
>> range
>> of cells.
>> Example:
>> RowA RowB RowC
>> Col1 P S W
>> Col2 4 2 1
>>
>> >
>> It's the OR that I can't figure out.
>>
>> Thanks a Bunch!
>

From: Teethless mama on 31 Mar 2010 13:23
=SUM(SUMIF(A1:C1,{"P","S"},A2:C2))


"parls" wrote:

> I've been trying to figure this out on my own based on other similar posts
> but I think I just don't understand array formulas. Anyway... I want to sum a
> range of cells if 1 of 2 possible criteria are met within a different range
> of cells.
> Example:
> RowA RowB RowC
> Col1 P S W
> Col2 4 2 1
>
> Sumif(A1:C1,"P" OR "S", A2:C2)
>
> It's the OR that I can't figure out.
>
> Thanks a Bunch!
 |  Next  |  Last
Pages: 1 2
Prev: Re Try This
Next: Return Value from a Range (depends on input to determind month