LINEST containing selection

B

Bob_Irving

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I'm trying to do a regression for one set of of data out of many in a table, selecting on the basis of a cell in another, using a formula thusly:

=LINEST(IF(SWHP_Refs=B5,SWCOP,),IF(SWHP_Refs=B5,SWLift,))

However, the LINEST function is, I think, including zeros in the regression for each row in the table not selected by the IFs, giving me erroneous answers, because it's dividing by a count of all the items in the table. If I remove the comma for the false value in the IF, it returns FALSE and LINEST does not like that.

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LINEST - supposedly same calculations but different RSQ-values. 0
Adding points to a graph "in the middle" of other graphs 1
How do I define a range by using cells as coordinates? 6
WHY Excel insert new sheet to the left of sheet 1? 3
MSGBOXes in user defined function 1
Excel - Counting cells/ranges with a particular fromat 2
how do I create formula for if a valuegreater that zero is added it shades another cell? 1
adding columns to a worksheet 1

Top