View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Sumproduct with nested sum

Glad to hear you got it from Topper's suggestion. Pl dismiss the earlier
thought. It wasn't quite relevant here.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"sahafi" wrote in message
...
Thanks Max for the reply, but i'm not sure how would that automate the
process. Is that mean I have to change the range each period? Because the
data comes in for the entire year (13 period), and I only needed to sum
what
I need according to my current period.
Toppers example will do the job for now.

Thanks.