Hi all

I am really stuck in solving this problem and would be grateful for any
help.

I have a column of cells in which some cells contain text, some values
and some the results of calculations. i.e.

B2 contains heading text
B3 contains A Name (The result of a VLOOKUP)
B4 contains 11452
B5 contains 12.05
B6 contains 8 (the result of a calculation)
B7 contains heading text
B8 is blank (awaiting result of a VLOOKUP)
B9 is blank (awaiting input)
B10 is blank (awaiting input)
B11 contains #N/A (Awaiting the result of a calc using data from B7,B8
and B())

This pattern continues in blocks of 5 cells to R63 in which I want to
use a function to total the contents of cells B6, B11, B16, B21 etc.
Since some of these cells contain calculated numeric values and some
contain #N/A (still awaiting their content to be calculated, as
sporting events take place) a SUM function or a =B6+B11+B16+B21 results
in another #N/A error.

Would be grateful to know how I can add this column of selected
non-adjacent cells in which there is a number containing #N/A. I need
the sum of the valid numbers without the need to be selective at the
time. I have approx 40 such columns needing a snap shot total every 15
mins.

with best regards


--
Jeeper
------------------------------------------------------------------------
Jeeper's Profile: http://www.excelforum.com/member.php...o&userid=24107
View this thread: http://www.excelforum.com/showthread...hreadid=377157