Hi guys,

I have a ('start:end') function that's not working. A simplified example is shown below in the screen shots.

I want a given cell in sheet1 to produce the sum of factors within a given column/row arrangements and equations from sheet3 and sheet4.

I've tried all the arguments I can think of in their proper places including the ' arguments before and after start:end but nothing seems to work. My resulting answer is usually #REF!

Can suggestions and help?

sheet1.png
sheet3.png
sheet4.png
worksheets.png

Thanks