how can avoid considering of blank cells in IF function

G

Guest

I am using the following formulas:
=IF(H8=J8,"1","0")+IF(H10=J10,"1","0")+IF(H12=J12,"1","0")
but is counting also the blank cells. I would like to compar the cells when
there are numbers (including zero) inside (not blank).
 
A

Aladin Akyurek

=(COUNT(H8,J8)=2)*(H8=J8)+(COUNT(H10,J10)=2)*(H10=J10)+(COUNT(H12,J12)=2)*(H12=J12)
 

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

Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. 1
Please help with SUM formula dependent on results of other cells 2
Combination of IF, AND, and COUNTIF; need help 6
Ignore blank cells when calculating date for If, Then function 2
AVG or Return 1 value from either of 2 cells if one is blank 8
"If" function and blank cells 5
How to count the maximum number of consecutives? 9
IF cells are empty 4

Top