Formula Help
 

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

Formula Help
 

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

Formula Help
 

=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.
--
David Biddulph

"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