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!