| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help...Summing Items Scattered in a list
Greetings again O Great ones! I need a total sum of an item that my be scattered several times in a list. For example, lets say the following is A1 thru B4 in a spreadsheet. ProjectX $10 ProjectY $5 ProjectZ $10 ProjectX $2 I need to calculate the total $ for ProjectX. In this case the result should be $12. -- modicon2 ------------------------------------------------------------------------ modicon2's Profile: http://www.excelforum.com/member.php...fo&userid=4158 View this thread: http://www.excelforum.com/showthread...hreadid=573797 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help...Summing Items Scattered in a list
Use SUMIF:
=SUMIF([range],Project X) Dave -- Brevity is the soul of wit. "modicon2" wrote: Greetings again O Great ones! I need a total sum of an item that my be scattered several times in a list. For example, lets say the following is A1 thru B4 in a spreadsheet. ProjectX $10 ProjectY $5 ProjectZ $10 ProjectX $2 I need to calculate the total $ for ProjectX. In this case the result should be $12. -- modicon2 ------------------------------------------------------------------------ modicon2's Profile: http://www.excelforum.com/member.php...fo&userid=4158 View this thread: http://www.excelforum.com/showthread...hreadid=573797 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto updating list | Excel Worksheet Functions | |||
| List items in column | Excel Worksheet Functions | |||
| Checking for duplicate items in list | Excel Worksheet Functions | |||
| Random items from a list? | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Linear Mode
