Sum 90% of values in a colunm

**wlln001** · 05-13-2009, 11:47 AM

Hello

I have a columns of data that I need to sum, but I only need to sum 90% of the total cells...

The colunm is sorted in ascending order so the larger figures are at the bottom.. The final 10% of these figures need to be excluded from the sum..

can anyone help

regards

**sweep** · 05-13-2009, 11:52 AM

Presuming your data starts at A1

=SUM(OFFSET(A1,0,0,INT(0.9*COUNT(A1:A10000)),1))

**wlln001** · 05-13-2009, 12:01 PM

Sweep... you are a star.. it works a treat..

many thanks

**royUK** · 05-13-2009, 12:25 PM

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

Moved to Functions Forum