| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Type of SUM formula ???
Hi, I am trying to find the last entry of a column, in order to add /
subtract from other sums. Is there a way to do this? the work-around using is: using a work column: =IF($G5="",$G4,0) and entering 0 in unused rows, then can use: SUM(H4:H26)-$O$30 can I replace that with something else, and get rid of the work column? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot see formula descriptions in worksheet as I type a formula. | Excel Worksheet Functions | |||
| Look for a certain type of formula... | Excel Discussion (Misc queries) | |||
| Look for a certain type of formula... | Excel Discussion (Misc queries) | |||
| Not sure what type of Formula to use... | Excel Discussion (Misc queries) | |||
| "IF" type formula | Excel Discussion (Misc queries) | |||
Threaded Mode
