From: BobT on 10 Feb 2010 12:21 I need to total a column of numbers eg 'R' but only if the column 'I' says 'DES'. -- BobT From: Gary''s Student on 10 Feb 2010 12:45 =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 From: Daryl S on 10 Feb 2010 12:48 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 From: Teethless mama on 10 Feb 2010 12:50 =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 From: Fred Smith on 10 Feb 2010 13:07 Daryl, Sumproduct is not an array function. Using Enter will suffice. Regards Fred "Daryl S" wrote in message news:FF21707C-CE1A-4AE0-B620-B1DA111A79B6(a)microsoft.com...> 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  |  Next  |  Last