SUMIF function not working with Date

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

Guest

I am trying to use a SUMIF function where the criteria is a cell with a date in it but it returns 0.
e.g. =SUMIF((D27:D41,"<(F6)",E27:E41)
I have tried DATE, DATEVALUE and various other things but it always returns 0, however if I use the formula with the actual date in it
i.e. =SUMIF(D27:D41,"<20/04/04",E27:E41)
then it returns the correct result

I am stumped - can anyone help?
 
Thank You it works - simple when you know how!!

Could you help me with this then - using the same function how can I return all the values that are between 2 dates in different cells

E.g the criteria in the function would be < F6 and >F7
Can I do this in SUMIF??

Thank You
 
=SUMPRODUCT(--(D27:D41<f6),--(D27:D41>f7))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

SL said:
Thank You it works - simple when you know how!!

Could you help me with this then - using the same function how can I
Click to expand...
return all the values that are between 2 dates in different cells
 
Back
Top