Sumif criteria

  • Thread starter Thread starter Louis Zaffino
  • Start date Start date
L

Louis Zaffino

In the criteria section of the Sumif formula if I reference a date (ex.
"<A3") I do not get the correct answer but if I in put the serial number of
that date (ex."<39251") I do get the correct response. Why is this?
 
hi
the sumif formual is looking for what is between the double quotes literally
and the cell does not contain A3. write your formula criteria more like
this....
=sumif(search range,"<"&A3, sum range)
the ampersand concatinates the less than sign and the value in A3.

Regards
FSt1
 
Use this instead...

"<"&A3
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Louis Zaffino"
wrote in message
In the criteria section of the Sumif formula if I reference a date (ex.
"<A3") I do not get the correct answer but if I in put the serial number of
that date (ex."<39251") I do get the correct response. Why is this?
 
Thank you very much for helping with criteria portion of the Sumif function.
Thanks for including the reasoning behind your suggestion. That will help a
lot in the future.
 

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

Like SUMIFS, but for multiplication?? 3
SUMIF - how to enter a second criteria 1
Setting a Timesheet with Dates 4
Where to put quotes in a SUMIF formula and when is & used for cell 2
Criteria Syntax in SUMIF formula 4
SUMIF Function 1
Sumif formula 4
how do you include todays date in SUMIF formulas 1

Back
Top