If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|