EXCEL
 

I need to total a column of numbers eg 'R' but only if the column 'I' says
'DES'.
--
BobT

EXCEL
 

=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

EXCEL
 

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

EXCEL
 

=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

EXCEL
 

Daryl,

Sumproduct is not an array function. Using Enter will suffice.

Regards
Fred

"Daryl S" wrote in message
...
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

EXCEL
 

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

EXCEL
 

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" wrote in message
...
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

.