Brute force way, until something more sophisticated comes along.........

=IF(COUNTA(A7:T8),SUM(A7:T8)+X4,0)-SUM(C7:D8)-SUM(S7:T8)

Vaya con Dios,
Chuck, CABGx3



"bbc1" wrote in message
...
I have a formula that sums the total accrss a series of cells and then
adds
the total of the cell above it.
=IF(COUNTA(A7:T8),SUM(A7:T8)+X4,0)
What I am trying to do is have the same formula but have it not add cells
C7:D8 and S7:T8