Countif

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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
 
Sorry, I meant to post this in the funtion group. I didn't
realize i was still the programming group.

Steve
 
You must log in or register to reply here.

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

Macro Error 4
Excel Need Countifs Formula Help 0
Excel. VBA match doesnt work while WS does 0
VBA Countif across sheets? 5
Countif Multiple Criteria 3
Assembling Data of Many Sheets in one Summary Sheet 3
Match function in VBA 14
Excel Use COUNTIF across a range of cells with formulas 0

Back
Top