Formula Help

B

bbc1

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
 
C

CLR

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
 
D

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.
 
Top