I can't seem to figure out why this formula will not work. I have data that
has records with various blanks. I wanted the exponential growth forecast on
just years without blanks. The data looks like this:

2007 2006 2005 2004 2003 2002 2001 etc.
4,260 4,250 4,540 4,560 4,550 3,890 etc.

I wrote an array if statement like this:
{=GROWTH(IF(A2:Z2<"",A2:Z2,""),IF(A2:Z2<"",A1:Z1 ,""),2032)}

Can someone let me know how to fix this? thank you!