#### Oprichnick

##### Board Regular

- Joined
- May 30, 2013

- Messages
- 69

I'm trying to use a Forecast function in which I just want to use the non blank cells. The formula:

=FORECAST($QG$7;IF(PW8:QF8<>0;PW8:QF8);IF(PW8:QF8<>0;$PW$7:$QF$7))

In the second block of the Forecast function "IF(PW8:QF8<>0;PW8:QF8)" it returns only the non blank cells;

However in the third block "IF(PW8:QF8<>0;$PW$7:$QF$7)" it returns me all x values.

I want to use only the X values to which there are Y values.

Thanks in advance,

Pedro