| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed on possible countif..
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help needed on possible countif..
Fantastic, thanks
"Mike H" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help needed on possible countif..
How about:
=countif(a1:d1,"<"&e1) 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? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Rows With Non-Needed Data between Needed Data | Excel Worksheet Functions | |||
| countif formula needed | Excel Discussion (Misc queries) | |||
| fomula help needed on countif | Excel Discussion (Misc queries) | |||
| CountIf Function Help Needed | Excel Worksheet Functions | |||
| Countif help needed | Excel Discussion (Misc queries) | |||
Linear Mode
