sum and sumif formulas in a workbook

**bfontenot** · 2014-09-11, 03:03 AM

000SAMPLE COMPILED Daily PJM Report.xlsx 000SAMPLE COMPILED Daily PJM Report.xlsx

I need to total the cumulative hours in each daily worksheet and travel hours daily

I thought i had the formula for the total hours using '*' as wildcard but when i add sheets it doesnt add into the formula...i will add sheets as needed for the dates on a particular project

1st i need help with the TOTAL HOURS on each date considering the fact that i will be adding sheets when necessary

2nd (still considering that i'll be adding sheets when needed) i would like to total the travel time cumulatively (using travel as a keyword in B10 through B19 to total the time to the right of it in Q10 through Q19) ---'travel' may end up being anywhere in B10-B19 or more than once daily b/c I may have different techs with different times on the same day

hopefully i explained myself well enough/// and hopefully the attachment is there (new here)Thanks in advance!

**bfontenot** · 2014-09-11, 04:48 AM

after looking at it again I'm now adding Q20 from each sheet with the result placed in 'Total Hours' (B1) (i moved things around in Total Hours from what i originally attached)

then, in each sheet i now have a 'total travel' which can be calculated (per sheet looking for keyword 'travel') then the total placed in 'Total Hours' (B2)

...much simpler way but i still have an issue if i add sheets Are my only 2 options to re-run the formula in the Total Hours sheet as i add worksheets or to use the start/end sheet method?