Error in formula

[[email protected]]

Hi I am trying to use a spreadsheet to show the available man hours we have to schedule work in our factory. We are usning a sheet that our manager fills in with the holidays and I'd like a formula that adds up the cells with no text as 6.8hours and if theres text in them, ie HOL/PLAN, then it ignores it. I tried this

=SUM(IF(D5>A,0,6.8),IF(D6>A,0,6.8),IF(D7>A,0,6.8),IF(D8>A,0,6.8),IF(D9>A,0,6.8),IF(D10>A,0,6.8),IF(D11>A,0,6.8),IF(D12>A,0,6.8))

But it doesn't seem to work.

heres a sample of whst the sheet looks like.

[RobertMika]

=COUNTBLANK(E$6:E$13)*6.8
Drag accross

[Olly]

In cell E14, use:

Please Login or Register  to view this content.

Tweak / copy as necessary.