Combination of SUMIFS

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