MY DAY HAS GONE TO PIECES

[HUSKER55]

Just when you thought it couldn't get worse.

I want to count 3 cells, a1 d1 m1. (count(a1,d1,m1))

If I remove data from the cell the formula doesn't reset. For example, if d1 is blank or 0 the count says three.

I am thinkg of taking up drinking as a profession. :D

thanks hope your day is better than mine.

[headhawg]

In Excel, the Count function counts numbers and 0 is a number. =COUNT(A1,D1,M1) will work fine if there are blanks instead of zeroes.

[HUSKER55]

crap!

thanks!