Thread
:
Sum the first x cells in a range
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
Robert_L_Ross
external usenet poster
Posts: 35
Sum the first x cells in a range
No, because on month three of the year, it would be =sum(e5:g5) while on
month 10 of the year it would be =sum(e5:n5).
"Don Guillett" wrote:
I guess =sum(e5:m5) wouldn't do?
--
Don Guillett
SalesAid Software
"Robert_L_Ross" wrote in message
...
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?
Reply With Quote
Robert_L_Ross
View Public Profile
Find all posts by Robert_L_Ross