A time sheet arithmetic issue

[jPaulB]

Hi everybody,

I've drawn up a time sheet to keep track of my own hours worked.

The layout is pretty simple... I have seven three-column groups across the page, one group for each day of the week.

The columns in each group are named "Time In" "Time Out" and "Hours Worked"

At the tail end of each seven groups is a cell ("TOTAL") that ought to add the values of the "Hours Worked". The columns for "Hours Worked" are
D H L P T X AB

The formula to do this is: =SUM(D6+H6+L6+P6+T6+X6+AB6) and it works well, as long as there are values in each of the "Hours Worked" cells.

The issue I have is that I can not adjust that formula to account for any days off, which will vary. If any one of the seven "Hours Worked" cells contain a null value, then the "TOTAL" cell will display #VALUE!

So now I'm stuck and confused.

My formula in the "TOTAL" column will have to somehow have to allow for null values in some or all of the "Hours Worked" cells.

I would like the "TOTAL" cells to display a null for any future weeks that have no values in any of the weekly spreads,
but allow for a days off in weekly spreads that do have history.

Can anyone help me express THAT in an =IF() statement?

Many thanks,
Paul

[bebo021999]

SUMIF can do that :
Assuming row #1 contains column's name: D1,H1,...,AB1 = "Hours Worked"
The SUMIF for row #6:
=SUMIF($D$1:$AB$1,"Hours Worked",D6:AB6)
Copy down for other rows

[jPaulB]

Works like a charm!

Now if I can just understand SUMIF, and I eventually will.

Thank you, sir
Paul