Note that although this formula is shorter than the index version it is also
volatile so it will always recalculate regardless whether you do any changes
or not. That means that if you just open the workbook it will ask if you
want to save it when you close it


--
Regards,

Peo Sjoblom


"Robert_L_Ross" wrote in message
...
This also works...thanks for another option!

"Toppers" wrote:

=SUM(OFFSET($E$5,0,0,1,D4))

D4 is count of columns e6:p6

HTH

"Robert_L_Ross" wrote:

Weird one, but I know someone out there knows how to do this...

I have two rows, this fiscal year and last fiscal year.
I have a count of the cells that have values for this fiscal year
(let's say
the count of cells e6:p6 is 8).
I want to then sum the first 8 cells in row 5 (e5:p5) so I can return
last
fy to date compared to this fy to date.

How would I build a function that would sum the first 8 cells in row 5?