Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif criteria sg
i have a column (column B) of cells with numbers in the cells. i want to
count for. example, how many cells have a number between 12 and 29. i used =countif(B:B,"=12 and <=29") but it did not work. =countif(B:B,"=12,<=29") also did not work. what is the correct syntax for the criteria in the formula? thanks for your help fred |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two criteria for CountIf? | Excel Worksheet Functions | |||
COUNTIF with two criteria | Excel Worksheet Functions | |||
Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
countif criteria | Excel Worksheet Functions |