Countif
 

I need to use a countif function to find the number of
cells with a number less than zero in them. The problem
is, the range is 4 misc. cells. d55, d118, d173, d191. i
entered the cells individually (countif
(d55,d118,d173,d191, "<0")and i am getting an error. Can
anyone help?


Thanks for your time,
Steve

Countif
 

Sorry, I meant to post this in the funtion group. I didn't
realize i was still the programming group.

Steve
-----Original Message-----
I need to use a countif function to find the number of
cells with a number less than zero in them. The problem
is, the range is 4 misc. cells. d55, d118, d173, d191. i
entered the cells individually (countif
(d55,d118,d173,d191, "<0")and i am getting an error. Can
anyone help?


Thanks for your time,
Steve
.