| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to total col, but pick up number in other col. if not 0
I have two columns of figures i.e. Col. G has figures in each cell and have
totalled them and averaged them. In Col. F most of the cells have 0, but if a cell is populated with a figure other than 0, then I need to use that figure instead of the figure in Row G. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TOTAL NUMBER OF ENTRIES | Excel Worksheet Functions | |||
| Add total number of rows (text) in a column | Excel Worksheet Functions | |||
| Counting the total number of cells with specified condition(freque | Excel Discussion (Misc queries) | |||
| How do I pick a number from a list in Excel? | Excel Worksheet Functions | |||
| a number as a percentage out of a total | Excel Worksheet Functions | |||
Threaded Mode
