Z
Zakynthos
I have up to 7 time-formatted data in between c3-p3.
I want to count all valuies except those showing as "00:00", then divide the
result by 2.
Should I do this with COUNT or COUNTIF and if so, what would be the form of
the expression?
Many thanks for your help.
I want to count all valuies except those showing as "00:00", then divide the
result by 2.
Should I do this with COUNT or COUNTIF and if so, what would be the form of
the expression?
Many thanks for your help.
3;"<>0:00") should do the trick.