| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| What is the formula to display a negative time results? | Excel Worksheet Functions | |||
| 'Time to Fix' Formula | Excel Discussion (Misc queries) | |||
| Formula to deduct unpaid breaks in time sheet | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
