Formula Help

[Guest]

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
C78 and S7:T8

 

[CLR]

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

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

Vaya con Dios,
Chuck, CABGx3

 

[David Biddulph]

=IF(COUNTA(A7:T8),SUM(A7:B8,E7:R8)+X4,0)
or
=IF(COUNTA(A7:B8,E7:R8),SUM(A7:B8,E7:R8)+X4,0)
depending on what you want.