|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 10th, 2010, 05:21 PM
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
February 10th, 2010, 05:45 PM
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
February 10th, 2010, 05:48 PM
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
February 10th, 2010, 05:50 PM
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
February 10th, 2010, 06:07 PM
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
February 10th, 2010, 09:52 PM
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
February 11th, 2010, 05:53 PM
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 .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
