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).
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).
=(COUNT(H8,J8)=2)*(H8=J8)+(COUNT(H10,J10)=2)*(H10=J10)+(COUNT(H12,J12)=2)*(H12=J12)
Lika wrote:
> 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).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks