Count cells with numbers

[Toota]

Hi there,
I have a spreadsheet with Hours worked in certain cells being D6,F6,H6,J6 and L6
These cells represent days.
I would like to put a formula into another cell being W4 that counts the number of days worked?
I do not want to count E6, G6 etc as they represent overtime
Any help would be appreciated?
Thanks

 

[Marcelo Branco]

I suppose you want to sum the days worked.
If so, try
=SUMPRODUCT(--(MOD(COLUMN(D$6:L$6)-COLUMN(D$6)+1,2)=1),D$6:L$6)

M.

 

[Michael M]

How about

=COUNTIF(D6:L6,"<>")-SUM(COUNTIF(INDIRECT({"E6","G6","K6"}),"<>"))

 

[Toota]

Thank you Michael M
Marcelo i didnt try yours as i did not want to sum the hours.
Appreciate the responses

 

[Michael M]

Glad we could help...

 

[Peter_SSs]

What about simply

=COUNT(D6,F6,H6,J6,L6)