B
BobT
I need to total a column of numbers eg 'R' but only if the column 'I' says
'DES'.
'DES'.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
=SUMPRODUCT(--(I1:I100="DES"),R1:R100)
D
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)
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)
T
Teethless mama
=SUMIF(I:I,"Des",R:R)
F
Fred Smith
Daryl,
Sumproduct is not an array function. Using Enter will suffice.
Regards
Fred
Sumproduct is not an array function. Using Enter will suffice.
Regards
Fred
J
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>.
when not required because only 1 IF condition needs to be evaluated.
Bonus points for most efficient and fast operating solution <g>.
D
Daryl S
Thanks Fred - I stand corrected. The forumula is still good.