Hi there all
I have a cell where i want to output the sum of numbers. (Z10)
There are conditions behind these numbers either person A or person B and shift 1 or shift 2.

Is there anyway for the value of Z10 to reset to zero when either of the conditions change and then start again?
Im guessing its a variation/combination of =SUMIFS(F13:F362, C13:C362, "A", D13:D362, "1"), where F13:F362 are the values i wish to sum and columns C and D give the different conditions

Sorry if this is not very well explained and i will try to answer any questions
Many thanks in advance for any help offered

Tim