Prev: Windows 7 moving desktop icons
Next: Paste to size
From: Morgan on 20 Apr 2010 01:00
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
 | 
Pages: 1
Prev: Windows 7 moving desktop icons
Next: Paste to size