| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using Count function with a conditional range
I have a spreadsheet with dates in column A and a true/false in column B. I
want to count how many "false" are in column B between certain dates. If I specify the cells where the date range starts and finishes, this works OK e.g. =COUNT(A241:A265,0) What I want to do is replace A:241:A265 by an expression that selects the cells in column A that lie between two dates. Any ideas? Thanks Phil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
| creating function (vba) with range arguments | Excel Worksheet Functions | |||
| Conditional average function | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Threaded Mode
