Sumif criteria

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?
 
F

FSt1

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
 
J

Jim Cone

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?
 
L

Louis Zaffino

Thank you very much for helping with criteria portion of the Sumif function.
 
L

Louis Zaffino

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

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
How to Create an S-Curve from Custom Field? 0
Template with fields and premade texts.. 0
Use TODAY() function as the criteria in a SUMIF formula 1
Copy previous record into form field 0
Display weeks from a Milestone 0
SUMIF evaluating blank DATE data 2
How to use/create code in MS Word to calculate age? 0

Top