| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum last 3 values
Good morning
I need to sum the last 3 values in a range that can contain empty cells. A1 2.2 A2 A3 4.3 A4 1.7 A5 2.2 A6 A7 3.4 A8 A9 1.0 A10 So I need to sum 1.0, 3.4 and 2.2. The closest I've come is a formula that sums the row numbers themselves: 9, 7, 5 and not the values in the cells. TIA Lisa |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
| How sum values in column B using values in column A as the conditi | Excel Worksheet Functions | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| Leading Zeros in Numeric Values | Excel Worksheet Functions | |||
Threaded Mode
