Formula inside the TREND function

[ankozaver]

<dir>I would like to use fomulas to generate y-values on the fly to be used in a TREND function like =TREND({sum(5,A1),sum(1,A2)},{3,2},7). But this doesnt seem to work as it seems input array elements are not allowed to be formula themselves. Storing sum(5,A1) & sum(1,A2) on other cells and referencing them as input range is not an option. Is there any solution to this? Thank you!
</dir>

 

[Domenic]

Try...

=TREND(CHOOSE({1,2},SUM(5,A1),SUM(1,A2)),{3,2},7)

Hope this helps!