| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing a cell with Countif
Hi. I am trying to reference cell O7 in this countif function.
=COUNTIF(O8:O50000,-"<&O&7") Can anyone help me with this one? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Referencing a cell with Countif
I guess your criteria is supposed to mean less than O7?
Try it like this: =COUNTIF(O8:O50000,"<"&O7) -- Biff Microsoft Excel MVP "rhhince" wrote in message ... Hi. I am trying to reference cell O7 in this countif function. =COUNTIF(O8:O50000,-"<&O&7") Can anyone help me with this one? Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Referencing a cell with Countif
=COUNTIF(O8:O50000,"<" & O7)
-- Gary''s Student - gsnu2007k "rhhince" wrote: Hi. I am trying to reference cell O7 in this countif function. =COUNTIF(O8:O50000,-"<&O&7") Can anyone help me with this one? Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Referencing a cell with Countif
Hi,
I'm not sure what the minus sign was for, try this =COUNTIF(O8:O50000,"<"&O7) Mike "rhhince" wrote: Hi. I am trying to reference cell O7 in this countif function. =COUNTIF(O8:O50000,-"<&O&7") Can anyone help me with this one? Thanks. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Referencing a cell with Countif
And if the minus sign was a typo, then perhaps this is what you want...
=COUNTIF(O8:O50000,O7) Note: It is always useful to include descriptive text as to what you are trying to do rather than let a non-working formula try to convey it. -- Rick (MVP - Excel) "rhhince" wrote in message ... Hi. I am trying to reference cell O7 in this countif function. =COUNTIF(O8:O50000,-"<&O&7") Can anyone help me with this one? Thanks. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Referencing a cell with Countif
What worked was this:
=COUNTIF(O8:O50000,""&O7) and for counting negative numbers =COUNTIF(O8:O50000,"<"&-O7) Thanx for the help. On Jan 14, 2:17*pm, "T. Valko" wrote: I guess your criteria is supposed to mean less than O7? Try it like this: =COUNTIF(O8:O50000,"<"&O7) -- Biff Microsoft Excel MVP "rhhince" wrote in message ... Hi. I am trying to reference cell O7 in this countif function. =COUNTIF(O8:O50000,-"<&O&7") Can anyone help me with this one? Thanks. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Referencing a cell with Countif
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "rhhince" wrote in message ... What worked was this: =COUNTIF(O8:O50000,""&O7) and for counting negative numbers =COUNTIF(O8:O50000,"<"&-O7) Thanx for the help. On Jan 14, 2:17 pm, "T. Valko" wrote: I guess your criteria is supposed to mean less than O7? Try it like this: =COUNTIF(O8:O50000,"<"&O7) -- Biff Microsoft Excel MVP "rhhince" wrote in message ... Hi. I am trying to reference cell O7 in this countif function. =COUNTIF(O8:O50000,-"<&O&7") Can anyone help me with this one? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIf cell referencing | Excel Worksheet Functions | |||
| Countif referencing another WB | Excel Discussion (Misc queries) | |||
| COUNTIF using # ranges, and referencing 2 other columns | Excel Worksheet Functions | |||
| CountIF() in Worksheet B while referencing cells in Worksheet A | Excel Worksheet Functions | |||
| Referencing previous column in COUNTIF | Excel Discussion (Misc queries) | |||
![rhhince[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
