| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
The formulas given do work but you have a second option... Choose...Tools, Addins and turn on your conditional sum wizard...Then from the Tools menu choose 'conditional sum' and add whatever conditions you want to the grid as shown in the graphic i uploaded...last steps just ask you where you want your answer/s to land...choose however many cells you need to catch the final result. Luck to you NMP +-------------------------------------------------------------------+ |Filename: CSumWizard Example.JPG | |Download: http://www.excelforum.com/attachment.php?postid=3586 | +-------------------------------------------------------------------+ -- Padgett Master Certified Office Applications Instructor ------------------------------------------------------------------------ Padgett's Profile: http://www.excelforum.com/member.php...fo&userid=5670 View this thread: http://www.excelforum.com/showthread...hreadid=385838 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
| Adding formatted cells to an outline ? | Excel Discussion (Misc queries) | |||
| Adding muliple cells. | Excel Worksheet Functions | |||
| Adding muliple cells. | Excel Worksheet Functions | |||
| ADDING CELLS WHICH ARE <> THAN OTHER CELLS | Excel Worksheet Functions | |||
Hybrid Mode
