Hi
I was expecting that this formula =COUNTIFS($S$3:$S$500,"<"& D$4) would include the count of blank cells in the result, but it doesn't appear to.
I assumed that a blank cell would be a value of less than 31/9/18
Column S = list of dates
Cell D4 is the date that the I want to count the entries in column S if they are less than this
Any advice would be great thanks
Last edited by Gooford; 08-02-2018 at 10:13 AM.
If blanks are not counting, try this:
=COUNTIF($S$3:$S$500,"<"& D$4)+COUNTIF($S$3:$S$500,"")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thanks that's it much appreciated
You’re welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks