Help needed on possible countif..

G

GD

Hi, i have the following data set...

A B C D E F
1 12 57 101 0 90
2 12 57 88 0 90
3 12 57 76 0 90
4 12 57 204 0 90

I'm looking for a Countif formula in column F which will count how many
instances in Cells A-D are LESS THAN the value in E. I thought it would be
something along the lines of =COUNTIF(A1:D1, A1:D1<E1) but i get a zero?
 
D

Dave Peterson

How about:

=countif(a1:d1,"<"&e1)
Hi, i have the following data set...

A B C D E F
1 12 57 101 0 90
2 12 57 88 0 90
3 12 57 76 0 90
4 12 57 204 0 90

I'm looking for a Countif formula in column F which will count how many
instances in Cells A-D are LESS THAN the value in E. I thought it would be
something along the lines of =COUNTIF(A1:D1, A1:D1<E1) but i get a zero?
Click to expand...
 

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

possible COUNTIF? 5
Average with multiple conditions 4
countif, multiple value range PLEASE HELP 2
Vlookup Based on Multiple Conditions 4
Formula help needed 2
COUNTIF NON DUPLICATED ROWS 2
How do I set up a formula to give me an average based on IF? 1
Function help 7

Top