Hi everyone, I work for a charity and am trying to produce a report for some funders. I need to to count cells within a date range on sheet three and show how many cells fall within the date range on Sheet 1 - I have no idea why my formula doesn't work - please help!
=COUNTIFS('Sheet3!C5:C13',">="&D3,'Sheet3!C5:C13',"<="&F3)
The single quotes around the Sheet3 ranges are causing a problem. Use this:
Formula:
=COUNTIFS(Sheet3!C5:C13,">="&D3,Sheet3!C5:C13,"<="&F3)
firstly it should be
=COUNTIFS(Sheet3!C5:C13,">="&D3,Sheet3!C5:C13,"<="&F3)
or if sheet names have a space
=COUNTIFS('Sheet 3'!C5:C13,">="&D3,'Sheet 3'!C5:C13,"<="&F3)
secondly if it still doesn't work the dates are not real dates but text that looks like dates
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks