sumif formula
 

I have a summary sheet and a detail sheet. On the summary sheet I am trying
to sum columns (E - O) from the detail sheet that are less than or equal to a
date for a specific account in column A on the detail sheet. The problem
is that I do not know the row that the account falls on. So far I have
SUMIF(Budget_Cons!$E$4:$O$4,"<"&"="month,OFFSET(E4 ,MATCH($A9,A:A,0),0))

Thanks for your help!

sumif formula
 

Do columns E-O actually contain dates, month numbers, or something else, and
should we be summing them, or just counting them? Locating the account to
work with is the least of the problems here.


Taking your requirements as you've described them:

=SUMIF(OFFSET(Budget_Cons!$E$4:$O$4,MATCH(E4,Budge t_Cons!$A$4:$A$100,0)-1,0),"<="&month)

would work.



"Vince" wrote in message
...
I have a summary sheet and a detail sheet. On the summary sheet I am
trying
to sum columns (E - O) from the detail sheet that are less than or equal
to a
date for a specific account in column A on the detail sheet. The problem
is that I do not know the row that the account falls on. So far I have
SUMIF(Budget_Cons!$E$4:$O$4,"<"&"="month,OFFSET(E4 ,MATCH($A9,A:A,0),0))

Thanks for your help!

sumif formula
 

=SUMIF(Budget_Cons!$E$4:$O$4,"<="&MONTH(OFFSET(E4, MATCH($A9,A:A,0),)))

This will sum everything in E4:O4 that is less than the month of the date
found by the OFFSET function. Presumably, you'll actually want to sum
another range, something like:

=SUMIF(Budget_Cons!$E$4:$O$4,"<="&MONTH(OFFSET(E4, MATCH($A9,A:A,0),)),Range_to_Sum)



--
Best Regards,

Luke M
"Vince" wrote in message
...
I have a summary sheet and a detail sheet. On the summary sheet I am
trying
to sum columns (E - O) from the detail sheet that are less than or equal
to a
date for a specific account in column A on the detail sheet. The problem
is that I do not know the row that the account falls on. So far I have
SUMIF(Budget_Cons!$E$4:$O$4,"<"&"="month,OFFSET(E4 ,MATCH($A9,A:A,0),0))

Thanks for your help!