Need a formula to add the total # each time it finds a name
 

Here's how my current sheet looks like:


Code:
--------------------

Column A

Dept Units
Apparel 150
Apparel 142
Licensee 80
Footwear 64
Apparel 63
Footwear 62

Total Units
Apparel Formula
Licensee Formula
Footwear Formula

--------------------


I need a formula that will give me the total units for any dept labled
Apparel, Licensee, and Footwear. Every week the number of units will
change and I have to resort the list so the order is always different.
I'm thinking the best way to do it is for a formula to look for the
word Apparel and any time it finds it to add the units to a total.
Thanks in advance for any help.


--
Weasel
------------------------------------------------------------------------
Weasel's Profile: http://www.excelforum.com/member.php...o&userid=27206
View this thread: http://www.excelforum.com/showthread...hreadid=531917

Need a formula to add the total # each time it finds a name
 

I think that sumif() is the formula that you need.

Roger

"Weasel" wrote:


Here's how my current sheet looks like:


Code:
--------------------

Column A

Dept Units
Apparel 150
Apparel 142
Licensee 80
Footwear 64
Apparel 63
Footwear 62

Total Units
Apparel Formula
Licensee Formula
Footwear Formula

--------------------


I need a formula that will give me the total units for any dept labled
Apparel, Licensee, and Footwear. Every week the number of units will
change and I have to resort the list so the order is always different.
I'm thinking the best way to do it is for a formula to look for the
word Apparel and any time it finds it to add the units to a total.
Thanks in advance for any help.


--
Weasel
------------------------------------------------------------------------
Weasel's Profile: http://www.excelforum.com/member.php...o&userid=27206
View this thread: http://www.excelforum.com/showthread...hreadid=531917

Need a formula to add the total # each time it finds a name
 

Use SUMIF

=SUMIF(A2:A90,"=" &A100,B2:B90)

As an example,

A100 contains the literal "Apparel" ie. is the first cell under the TOTAL
so A101 would contain LICENSEE etc

HTH

"Weasel" wrote:


Here's how my current sheet looks like:


Code:
--------------------

Column A

Dept Units
Apparel 150
Apparel 142
Licensee 80
Footwear 64
Apparel 63
Footwear 62

Total Units
Apparel Formula
Licensee Formula
Footwear Formula

--------------------


I need a formula that will give me the total units for any dept labled
Apparel, Licensee, and Footwear. Every week the number of units will
change and I have to resort the list so the order is always different.
I'm thinking the best way to do it is for a formula to look for the
word Apparel and any time it finds it to add the units to a total.
Thanks in advance for any help.


--
Weasel
------------------------------------------------------------------------
Weasel's Profile: http://www.excelforum.com/member.php...o&userid=27206
View this thread: http://www.excelforum.com/showthread...hreadid=531917

Need a formula to add the total # each time it finds a name
 

=sumif($a$2:$a$7,a10,$b$2:$b$7)


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531917

Need a formula to add the total # each time it finds a name
 

Thanks, that worked perfectly


--
Weasel
------------------------------------------------------------------------
Weasel's Profile: http://www.excelforum.com/member.php...o&userid=27206
View this thread: http://www.excelforum.com/showthread...hreadid=531917