ExcelBanter - SUMIF ??

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIF ?? (https://www.excelbanter.com/excel-worksheet-functions/99946-sumif.html)

MarkH

SUMIF ??

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

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

All times are GMT +1. The time now is 02:45 AM.