0

I know that a formula can be applied on a range of cells by utilizing an intermediate column, but can I directly specify a range in a formula somehow?

E.g., is it possible to do something like this, to get the sum of the results of dividing each cell in E12-E26 by each cell in C12-C26:

=SUM(E12/C12:E26/C26)

An answer, either positive or negative, would be accepted.

migrated from datascience.stackexchange.com Apr 28 '16 at 18:57

This question came from our site for Data science professionals, Machine Learning specialists, and those interested in learning more about the field.

1

You should enter it as =SUM(E12:E26/C12:C26) followed by Ctrl-Shift-Enter on Windows or Command-Enter on Mac.It will then be treated as an array formula and the formula bar will show it as {=SUM(E12:E26/C12:C26)}

1

You could use Sumproduct to avoid having to array-enter

=SUMPRODUCT((E12:E26/C12:C26))

Just hit Enter.

Your Answer

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.