sorry for misunderstanding your lines below...

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

from your next line :
I don't want to sum all of the year, only the same months in the last year
that i have values for in this year.

regards,
driller
--
*****
birds of the same feather flock together..



"Robert_L_Ross" wrote:

That won't work - all cells have values (each represents a value for a month
in the prior fiscal year).

I don't want to sum all of the year, only the same months in the last year
that i have values for in this year.

"driller" wrote:

try =sum(e5:L5) with cross-fingers...

regards,
driller
--
*****
birds of the same feather flock together..



"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?