Help needed on possible countif..
Try
=COUNTIF(A1:D1,"<"&E1)
Mike
"GD" wrote:
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?
|