Vary number of cells to include in a SUM

[Jitsu_g]

Hello,
Hope someone can help.

I have a row of numbers in n consecutive cells

I require the sum of the first x cells where x<n

x is specified in another cell

Regards

Graham

[:) Sixthsense :)]

Please attach a sample workbook with expected output to get better understanding of your requirement

[Jitsu_g]

Example attached.
Thanks

[:) Sixthsense :)]

In N7 Cell

Please Login or Register  to view this content.