What formula to use??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried that formula; I'm not great with them, and there's a ) missing, so I
tried adding one in. Didn't work.
Column headers are in Row 1. My sheet with Jan-Dec dates is named Summary.
Dates are in E2-P2, E103-P103 (all January is down; per account is across).
The cell I'm trying to fill is D2 on sheet named Active.
Here's what I used:
=OFFSET('Summary'!$A$2,MATCH(A2,'Summary'!$A$2:$A$103,0),COUNTA(OFFSET('Summary'!$A$2:$P$2,1,1),MATCH(A1,'Summary'!$A$2:$A$103,0))-1)

Please help!!!
Thanks
Darcie
 
Hi
try:
=OFFSET('Summary'!$A$2,MATCH(A2,'Summary'!$A$2:$A$103,0),COUNTA(OFFSET(
'Summary'!$A$2:$P$2,1,1),MATCH(A1,'Summary'!$A$2:$A$103,0)-1,0))
 
It returns a value of either "01/00" or "#N/A". I have the format set to
date: 3/4, same format on both sheets. Is there any more info I can give you
that might help? I'm trying to rearrange the formula so that it works, but
like I said, I'm not great with them.
Thanks again,
Darcie
 
Back
Top