| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL
I need to total a column of numbers eg 'R' but only if the column 'I' says
'DES'. -- BobT |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
