I have searched and searched but cannot find anything to assist, so I
decided to start my own thread. I hope this is OK.
I need to sum the total of the first 3 populated cells from 5.
ie.
A1 3.5
A2 3.1
A3 2.6
A4 1.9
A5 5
I need A1+A2+A3. However it may not always be so simple, as some cells
may be blank.
ie.
A1 3.5
A2
A3 2.6
A4 1.9
A5 5
I need A1+A3+A4.
Is it possible to sum UNTIL 3 cells have been summed? Will I need to
work along a row instead of down a column?
Any help would be greatly appreciated.
--
boof bonk boosh
------------------------------------------------------------------------
boof bonk boosh's Profile:
http://www.excelforum.com/member.php...o&userid=35202
View this thread:
http://www.excelforum.com/showthread...hreadid=549670