| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Problem
I am trying count count the number of occurances of a value = or than
(E7+2) but cannot workout the syntax. Can anybody kindly point me in the right direction? =COUNTIF(E13:E15,(E7+2)) Mark |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Problem
Hi
=COUNTIF(E13:E15,"=" & (E7+2)) Arvi Laanemets "Mark W" wrote in message ... I am trying count count the number of occurances of a value = or than (E7+2) but cannot workout the syntax. Can anybody kindly point me in the right direction? =COUNTIF(E13:E15,(E7+2)) Mark |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Problem
Great stuff thanks Arvi
Mark "Arvi Laanemets" wrote in message ... Hi =COUNTIF(E13:E15,"=" & (E7+2)) Arvi Laanemets "Mark W" wrote in message ... I am trying count count the number of occurances of a value = or than (E7+2) but cannot workout the syntax. Can anybody kindly point me in the right direction? =COUNTIF(E13:E15,(E7+2)) Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| importing csv files, problem with date formats | Excel Worksheet Functions | |||
| CountIf & null values problem | Excel Worksheet Functions | |||
| countif problem | Excel Discussion (Misc queries) | |||
| Excel Display Problem | Excel Discussion (Misc queries) | |||
| problem with countif | Excel Worksheet Functions | |||
Hybrid Mode
