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.