SUMIF ??
maybe...
=SUMIF(Wachovia!G63:G114,"<"&g2,Wachovia!J63:J114)
And I'd use:
=SUMIF(Wachovia!G63:G114,"<"&date(2006,7,15),Wacho via!J63:J114)
MarkH wrote:
I am trying sum a list of checks only if they were dated earlier than the
date in 'g2'.
This formula only works if i put an actual date
=SUMIF(Wachovia!G63:G114,"<7/15/06",Wachovia!J63:J114) This works
=SUMIF(Wachovia!G63:G114,"<g2",Wachovia!J63:J114) This does not
Please help.
Thanks in advance,
Mark
--
Dave Peterson
|