| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding only cells with an X in it
Column G35 through G49 may or may not have the letter X in it based on the
product entered in Column A. Cells in Column R adds up the total of the amounts in Column B times Column F. I need to have 2 totals. One that totals only the cells in column G when there is an X showing and the second total (same row - different column) adding all the cells in column R. I hope I am making a clear question. I am sure the answer is simple, but I cannot figure this one out. Thanks. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding specific cells | Excel Worksheet Functions | |||
| adding cells after stripping numbers out of text fields | Excel Discussion (Misc queries) | |||
| Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
| Adding formatted cells to an outline ? | Excel Discussion (Misc queries) | |||
| ADDING CELLS WHICH ARE <> THAN OTHER CELLS | Excel Worksheet Functions | |||
Threaded Mode
