sum the numbers under criteria

**yjmmay34** · 08-12-2010, 11:58 PM

Hi, all . I need help with this problem. I want to sum the Qty if the Geo, Year, and Mon are same. then it should only the sum quantity left in the worksheet. Just like the sample i attached, please refer to it, which will be easier to understand.
Thank you!

**DonkeyOte** · 08-13-2010, 02:29 AM

Why not use a Pivot Table ?

Note: your results don't actually tie out to your data - Q1 Jul should be 896 given 597 for Jul is Q2

**yjmmay34** · 08-13-2010, 02:35 AM

Hi, Ote. because i manually do it, so there may be some errors. But i need a macro to run this part, as this is a part of my whole macro program. Please help. Thank you!