Hi All,

I am trying to produce a formula that sums based on two criteria but to scan over multiple tabs

I need the formula to accumulate numbers if they are in "Week 41" and under "Day"

So far I have come up with this but not sure if it is close or not:

=SUMIFS('>:<',$11:$11,"Week 41",$16:$16,"Day") the > and < are two empty tabs that all the tabs i need the formula to scan are between.

If anyone could help or has any questions to help answer it would be much appreciated,

Thanks.