EXCEL

[BobT]

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

 

[Gary''s Student]

=SUMPRODUCT(--(I1:I100="DES"),R1:R100)

 

[Daryl S]

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)

 

[Teethless mama]

=SUMIF(I:I,"Des",R:R)

 

[Fred Smith]

Daryl,

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

Regards
Fred

 

[JLatham]

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>.

 

[Daryl S]

Thanks Fred - I stand corrected. The forumula is still good.