Add Values From Non-Working Days to Monday Total

**ddavelarsen** · 10-02-2012, 07:37 AM

I am trying to add the total of items that come into the office during weekends and holidays, to the total for each following Monday. I can identify weekend and holiday days in an adjacent cell by its contents, either blank or zero. I wish to sum the incoming number of files from the weekend/holiday to the following Monday's work.

I believe I've attached an example of the values I'm trying to sum, with one set including a holiday ( three day weekend).

Anyone have any ideas? Suggestions deeply appreciated.

Thanks,
Dave

**ChemistB** · 10-02-2012, 09:40 AM

Try this in H8 dragged down

=IF(AND(ISNUMBER(C8),C7=""),SUMIF(C4:C7,0,B4:B7)+SUMIF(C4:C7,"",B4:B7)+B8,"")
Does that work for you? It assumes a 4 day weekend at most. I also cleared the cells where you had 0 on the weekend instead of blanks.

**ddavelarsen** · 10-02-2012, 10:15 AM

Originally Posted by ChemistB

Try this in H8 dragged down

=IF(AND(ISNUMBER(C8),C7=""),SUMIF(C4:C7,0,B4:B7)+SUMIF(C4:C7,"",B4:B7)+B8,"")
Does that work for you? It assumes a 4 day weekend at most. I also cleared the cells where you had 0 on the weekend instead of blanks.

Thank you, that does work. Now I just need to figure out how it does.

I'll amend our model with your solution and we're off to the races! Have a great day. Updated thread title and reputation, thanks again.