Sum by Weekly

Hello Experts!

I am Facing Problem how to Sum the Data by Week Wise

I have Asked this question in MrExcel.com but Didn't get the Answer

HTML Code: 

Hope I will get the Solution

Regards

Hi Hardeep

Your example isn't perfect as the data you have used isn't related to each other, but I got the gist.

Just to rationalise things I have used the data in your first sheet for Chandigarh and applied the equation you used in Ahmedabad.

SUMIF(Chandigarh!A189:A195,">0",Chandigarh!B189:B195)

You will see the ">0" sets the condition that the value must be greater than 0, as dates are numbers then this is true but "Total Mar" is text and so is false.

Good Luck

col