View Single Post
  #1   Report Post  
Phil
 
Posts: n/a
Default 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