Adding columns - with tech info

  • Thread starter Thread starter Katherine
  • Start date Start date
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))
 
=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding columns with dates - 2
Adding columns with dates 1
if it looks like it matches, it's a match 1
Try to be more precise 4
2 Columns total division 4
Sumproduct where cell values are the same in a sorted column 1
Userform not working 1
Mandatory Cell check on multy page workbook 4

Back
Top