SUMIF ??

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

Guest

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
 
maybe...
=SUMIF(Wachovia!G63:G114,"<"&g2,Wachovia!J63:J114)

And I'd use:
=SUMIF(Wachovia!G63:G114,"<"&date(2006,7,15),Wachovia!J63:J114)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help? 3
Sumif on columns with logical answers 1
Add date condition 2
WHETHER TO USE COUNTIF, SUMIF or SUMPRODUCT 4
Sumif weekday 3
SUMIF with criteria "<>" & "=" 4
Choose dat range for sumif formula 1
Modify SUMIF to find data range in addition to value 4

Back
Top