Hi Bernie,

Thanks for the help.

I had a problem with the formula you gave and outlined it in the original
thread "Sumproduct help needed".

I played around with it and changed it to the following;

=SUM(OFFSET($B7:$B8,MAX(-(ROW($B7:$B14)-1),-(K$6-1)),0,MIN(ROW($B7),K$6),1))K$5

This works but I don't really understand why. I stumbled onto the changes.
Your thoughts on this would be appreciated. I haven't worked with OFFSET,
ROW, or MAX, MIN functions before.

Again, Thank you so much for your time and expertise. It is really
appreciated.

Martin