Sum Upto Intersecting Cells

[aaron_burr]

Hi, I have numerical references in my columns and similar in rows. The

See attached. In this instance, in cell C17 I would like to sum up to and including column '4' (4600). It needs to be dynamic and sum up to the corresponding month number in cell C4 as it changes. I believe a SUMPRODUCT is required but I cannot find the solution.

Thanks, Aaron.

[AliGW]

In D9 copied down:

=SUM(OFFSET(C9,0,0,1,MATCH($C$4,$C$8:$G$8,0)))

[AliGW]

Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[rorya]

Just as an alternative to avoid OFFSET:

=SUMIF($C$8:$G$8,"<="&$C$4,C9:G9)