I have a table, and one of the columns has a date value. I have a summary row and for this column I used COUNTA to display a count of the non-empty fields. I now also entered some comment text in this column if I don't have an actual date value. The COUNTA included the text as a non-blank cell. How do I change the formaula to ensure that I only count non-blank cells with date values? Thanks.
Maybe COUNT() rather than COUNTA()?
If you need any more information, please feel free to ask.
However, if this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the small Star icon botom left of thier post to show your appreciation.
Depending on whether you also have numbers in there, you might also use a COUNTIF or pair of COUNTIF formulas (one minus the other) to only count numbers within a certain range. Today is 40,854, starting from 1/1/1900.
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks