sum cells ignoring ones with blanks

i have a time sheet that calulates the hours worked per day and i want to add them up to give a total hours worked in a week.

The Cells in Column AO need to add up the cells in column (H,M,R,W,AB,AG,AL) but i keep having the issue that if one of those cells is blank (and i need it blank not 0) from the formula in that cell, then it returns # value or blank depending on the formula used. ( i have a couple of different ones in the cells that i have been testing)

copy attached.

Cheers

Try this instead... =SUM(H6,M6,R6,W6,AB6,AG6,AL6)

because the source cells are formula driven and i have a "" to give the blank cell, i think it wont sum because its thinking its text and numbers so get #value if i use a sum formula

Try it... it might surprise you...

i have tried it and it doesnt work, it stops working as soon as one of the cells is blank or has text in it

Did you keep the plus signs or did you change it to commas? It works on my end.

Ty!! i knew it was simple!! today i cannot get the simple stuff!

I'm glad it worked! Thank you for the rep!

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save