Adding columns - with tech info

K

Katherine

I have this formula to get my database to idenify when
there is no information to calulatate in the cells but it
is not working - can you help? Thank you -- Katherine

=IF(countA(L30,M30,O30,P30)=0,0,(M30=O30,N(Q30)+N(N30)-1,N
(Q30)+N(N30))
 
T

Tom Ogilvy

=IF(countA(L30,M30,O30,P30)=0,0,IF(M30=O30,N(Q30)+N(N30)-1,N
(Q30)+N(N30)))

You left out the second IF statement.
 
Top