CODEWITHSUNDEEP
excelexcel-formula
Diaco
Diaco

Reputation: 251

How to concatenate two functions into one function?

I have a set of data that is generated:

=((E31/320)^2)/(2+(E31/380))
=((E32/320)^2)/(2+(E32/380))
=((E33/320)^2)/(2+(E33/380))
...

I want to create a sum of these, but I don't want to just SUM them together; I want to write a function that put these together. I came up with this row:

=SUMPRODUCT(((ROW(E1:INDEX(E31:E63;C34)))/320)^2/(2 + (E31:E63/380)))

The problem with this line is it seems to overdo the whole thing. I need to somehow use one variable for the both E31:E63 intervals, because it will otherwise loop through the second E31:E63 n-times, instead of using the same value.

As I see it, there are two solutions.

  1. Write the data in columns, but using the first solution
  2. Write the function, but try to find something that makes the two E31:E63 work as one variable.

I want to implement the second option.

Upvotes: 0

Views: 62

Answers (1)

cybernetic.nomad
cybernetic.nomad

Reputation: 6368

I believe

=SUMPRODUCT(((E31:E63/320)^2)/(2+(E31:E63/380)))

Will do what you want.

Upvotes: 1

Related Questions