Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to Sum last 10 values of a dynamic column excluding zero
hi, i have this formula =SUM(OFFSET(P2,MATCH(1E+30,P:P)-1,0,-10,1)) which
sums the last ten values in column P, i was hoping someone could amend it slightly for me. As column P is dependent on other entries the entire column has 0 in it which makes this formula ineffective, i can't put an IF formula into column P because then that wrecks other formulas that need column P, so i need to work in a way of excluding zero into the forumla above. Also, the formula does not work until there are ten values in the column, is there any way to make it work and count the values up until the column gets ten entries? thank you for your help! -- thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Cells in a column depending on another column but excluding duplicates | Excel Discussion (Misc queries) | |||
How calculate a MIN excluding the 0 values | Excel Discussion (Misc queries) | |||
Excluding Error Values | Charts and Charting in Excel | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
excluding repeating values | Excel Discussion (Misc queries) |