Excel Help please - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Excel Help please

Reddwarfposse5 Avatar
6y, 10m agoPosted 6 years, 10 months ago
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.
Tags:
Reddwarfposse5 Avatar
6y, 10m agoPosted 6 years, 10 months ago
Options

All Comments

(3) Jump to unreadPost a comment
Comments/page:
1 Like #2
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")
#3

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

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!