Sum columns and rows w/ relative inputs

B

behrens

Is there a function that allows you to set a starting
point and then sum x rows and y columns?

For example:
Function (a6,5,6)

A function that would would sum 5 rows across and 6
columns down starting with cell a6?

I am trying to dynamically sum different ranges (e.g. the
5 rows and 6 columns)without hardcoding this in?

The Offset will return the value in a cell x rows and y
columns, but is there a similar sum function?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top