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.
Thanks.

  1. Misc
  2. Excel
Groups
  1. Misc
  2. Excel
3 Comments

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:

=COUNTIF(A1:A7,"12:00")

Original Poster

imafish2002;7552123

Try … Try COUNTAhttp://office.microsoft.com/en-us/excel/HP052090271033.aspx?pid=CH062528311033


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
Avatar
@
    Text
    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