Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Countif Function
=COUNTIF(H3:H26,""&B3)-COUNTIF(H3:H26,"="& B4)
Finds all the entries B3 and <B4 by count the number B3 count the number = B4 Subtract the # =B4 from the # B3 Note: if you wanted the # =B3 and <=B4 =COUNTIF(H3:H26,"="&B3)-COUNTIF(H3:H26,""& B4) Dan E "ChrisG" wrote in message ... I am attempting to use Countif function, e.g. =COUNTIF(H3:H26,B3) however I wish to construct a conditional argument something like this: =COUNTIF(H3:H26,"B3 AND <B4") Having terribel time with syntax or just not doable. Please help. Thanks Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
countif function | Excel Worksheet Functions | |||
COUNTIF function | Excel Worksheet Functions |