Select multiple areas when using Linest

[munco]

I am trying to select multiple areas for the x values in Linest.
Below is what I tried

=LINEST($B$2:$B$43,(C2:C43,E2:E43))

Does anyone know the correct code?

Thanks

 

[Andrew Poulsom]

Welcome to the Board.

Sorry, no can do:

http://www.tushar-mehta.com/excel/tips/multi_area_argument.html

 

[munco]

Thanks for the very quick response