Hi,
I'm trying to figuring out if it's possible to use linest with a conditional array. I've attached a similar spreadsheet with less data than the one I'm using. Basically, I'd like the known y's and x's to come only from a unique reference (ex. WIDGET). If column A has multiple values with "WIDGET" and column B has multiple corresponding y data, how can I change LINEST to reference just 1 unique value from column A (ex Widget) but sort's through all of that values y data?
I have tried.

=LINEST(IF($A$2:$A$7=E2,$B$2:$B$7,""),IF($A$2:$A$7=$E$2,$C$2:$C$7,""))

Thanks in advance!
LINEST example.xlsx