Prev: Re Try This
Next: Return Value from a Range (depends on input to determind month
From: parls on 1 Apr 2010 11:17
Awesome! That worked perfectly. For some reason when I tried to use the
sumproduct formula it returned "N/A".

"Teethless mama" wrote:

> =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!
First  |  Prev  | 
Pages: 1 2
Prev: Re Try This
Next: Return Value from a Range (depends on input to determind month