Can't workout formula in table

I've been trying to create a formula for the following table all day, but with no luck, please see attached..

In this table I do not want to count any minus numbers or a figure above 553should the figure 553 appear in the table, then any figures in rows above 553 are also void and are not to be added to the total.

Is this possible?

P.S the total of table B is correct and what I am after. The colours are for your benefit and not important

cheers

Originally Posted by JUBA

I've been trying to create a formula for the following table all day, but with no luck, please see attached..

In this table I do not want to count any minus numbers or a figure above 553should the figure 553 appear in the table, then any figures in rows above 553 are also void and are not to be added to the total.

Is this possible?

P.S the total of table B is correct and what I am after. The colours are for your benefit and not important

cheers

Hi,

in G3 put

=IF(F3=553,0,IF(C3>0,C3+G2,G2))

and fill that down as required.

hth
---