Found 15th Jan 2010
Can anyone help with a formula for Excel please. I know the basics but struggling with this one.
I'm looking for a formula that will total up the number of boxes with data in them, no matter what the entry.e.g. if 3 out of 7 boxes have a time value, then it returns 3 as the answer. I tried using COUNTIF but must be using it wrong.

  1. Misc
  2. Excel
  1. Misc
  2. Excel

yup - countA is the one you want... e.g. if you numbers are in cells A1:A7 - =COUNTA(A1:A7)

If you are looking for a specific time - e.g. you are looking for all 12:00 from the range, then you can use this:


Original Poster


Try … Try COUNTA

Quick reply, thanks. That works fine thanks. Just have to make sure not to even have a space in the empty cell.
Post a comment
    Top Discussions
    1. Is there a way to add ethernet to MIFI device?35
    2. landlord trying to get tenant to purchase a new bed when the old one was al…79
    3. Any ideas for eye glare protection from computer screens?22
    4. Electric Bike Advice.11

    See more discussions