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
|