Prev: Change How Tab Operates
Next: Cell Color Recognition and Summing of Data Within a Specified Colo
From: JLatham on 10 Feb 2010 16:52
Dat's da 1 I'd have used! All too often we get fixated on SUMPRODUCT() even
when not required because only 1 IF condition needs to be evaluated.

Bonus points for most efficient and fast operating solution <g>.

"Teethless mama" wrote:

> =SUMIF(I:I,"Des",R:R)
>
>
> "BobT" wrote:
>
> > I need to total a column of numbers eg 'R' but only if the column 'I' says
> > 'DES'.
> > --
> > BobT
From: Daryl S on 11 Feb 2010 12:53
Thanks Fred - I stand corrected. The forumula is still good.

--
Daryl S


"Fred Smith" wrote:

> Daryl,
>
> Sumproduct is not an array function. Using Enter will suffice.
>
> Regards
> Fred
>
> "Daryl S" <DarylS(a)discussions.microsoft.com> wrote in message
> news:FF21707C-CE1A-4AE0-B620-B1DA111A79B6(a)microsoft.com...
> > Bob -
> >
> > Adjust the column lengths to your needs. This is an array formula, so
> > after
> > putting this in your result cell, press Ctrl|Sift|Enter instead of just
> > Enter.
> >
> > =SUMPRODUCT(--(I2:I13 = "DES"),J2:J13)
> >
> > --
> > Daryl S
> >
> >
> > "BobT" wrote:
> >
> >> I need to total a column of numbers eg 'R' but only if the column 'I'
> >> says
> >> 'DES'.
> >> --
> >> BobT
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Change How Tab Operates
Next: Cell Color Recognition and Summing of Data Within a Specified Colo