Well, your example didn't exactly show that !!

If you have variable (but known) monthly sales figures, you could put
these in a table somewhere and use VLOOKUP or a SUMPRODUCT formula.

Give a more realistic example of your data and what you want to
achieve.

Pete

On Nov 10, 6:02*pm, Bryan V wrote:
If the monthly sales stay constant, yes. *My issue is that monthly sales values vary.