Hello Biff,

Thank you for your help. Both you and Ron gave good working solutions.

Cheers and be well. Mike Finberg

"Biff" wrote:

Hi!

Try this:

=SUMPRODUCT(--(ISNUMBER(--LEFT(A2:A14,1))))*11

Biff

"kudu" wrote in message
...
Hello MVP's, Geeks, Newbies!!
I am an absolute 'DoDo' when it comes to Formulas, please help with the
following request: I have a spreadsheet with employees times (and 'OFF',
'H'
etc), see the example below of a typical Monday. Each shift is an 11 Hour
WORKING shift.
I would like to 'COUNT' all fields in each column that has a 'working
time'
and then MULTIPLY the 'count' by 11. What would be the easiest formula to
use??

Mon
OFF
7-19
7-19
6-18
H
T
7-19
7-19
OFF
19-7
9-21
OFF
H

THANKS for your answers, best regards.