Summing values associated with mixed labels

[Zero]

I have a long spreadsheet which records the dates, descriptions,
sources, and quantities of various purchased items. Simplified, a
description (gloves) appears in Column B and the quantity purchased
appears in Column D. Lets say that one day I bought 3 gloves, two days
later I bought 6, and three days after that I bought 2. Mixed in with
that I bought a number of other things, and sorting is not an option.
How can I look through the system and add up all the values in Column D
anytime "gloves" appears in Column B?

*** Sent via http://www.automationtools.com ***
Add a newsgroup interface to your website today.

 

[Frank Kabel]

Hi
try
=SUMIF($B$1:$B$1000,"gloves",$D$1:$D$1000)

 

[RagDyer]

Frank's formula has "gloves" hardcoded into it.
Perhaps you would like to use a "search cell", so that you could enter any
item into it and then obtain the total for that particular item.

Just change Frank's formula to replace "gloves" with any cell which you
would like to use as the "search items" cell.
For example, to use cell G1, enter this:

=SUMIF($B$1:$B$1000,G1,$D$1:$D$1000)

Needless to say, the spelling in G1 must match the spelling in the list.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi
try
=SUMIF($B$1:$B$1000,"gloves",$D$1:$D$1000)

 

[Zero]

Excellent, it works like a charm. Thank you very much!

Zero

*** Sent via http://www.automationtools.com ***
Add a newsgroup interface to your website today.