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!