Prev: Change How Tab Operates
Next: Cell Color Recognition and Summing of Data Within a Specified Colo
From: BobT on 10 Feb 2010 12:21
I need to total a column of numbers eg 'R' but only if the column 'I' says
'DES'.
--
BobT
From: Gary''s Student on 10 Feb 2010 12:45
=SUMPRODUCT(--(I1:I100="DES"),R1:R100)

--
Gary''s Student - gsnu201001


"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 10 Feb 2010 12:48
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
From: Teethless mama on 10 Feb 2010 12:50
=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: Fred Smith on 10 Feb 2010 13:07
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

 |  Next  |  Last
Pages: 1 2
Prev: Change How Tab Operates
Next: Cell Color Recognition and Summing of Data Within a Specified Colo