Combination of SUMIFS

**thare** · 07-31-2013, 04:44 AM

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

**gomathi7** · 07-31-2013, 08:33 AM

Hi, Find enclosed the file hope this meets your requirement, try this

=SUMIFS(F13:F16,C13:C16,"a",D13:D16,"b")

Regards
Gomathi

**thare** · 07-31-2013, 09:24 AM

Gomathi

Thanks for this. Not sure if i explained clearly enough originally. Unfortunately i cannot post a sample sheet to explain. UPDATE: Have now managed!!

I would like my calculation cell to reset to zero when [either] the column 1 entries change from A to B [or] the column 2 entries change from 1 to 2.
The calculation cell would then "sum" until any other change was made into either column.
Does your post cover this as well?

Many thanks
Tim