Hello. How do you write between 4300 and 4800 in a sumif. Is it this? <4300<=4800
Hello. How do you write between 4300 and 4800 in a sumif. Is it this? <4300<=4800
"Between" is fairly ambiguous.
When people say "between" what they really mean is greater than or equal to ___ and less than or equal to ___.
Is that what you want?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
yup equal to and less than or equal to.
You can't.
Best alternative: see http://www.excelforum.com/showthread...=1#post4149002
Much in the same way you cant do
Formula:Please Login or Register to view this content.
or
Please Login or Register to view this content.
Why can't I do this? =SUMIFS(June!G:G,June!D:D,">4300<=4800",June!E:E, "122002")
Do it like this...
=SUMIFS(June!G:G,June!D:D,">4300",June!D:D,"<=4800",June!E:E,122002)
Some moderator is going to "yell" at you!
Why don't you have "" around the last criteria? That's not working. I've attached a spreadsheet.
A couple of things...
In formulas, don't quote numbers as that turns them into TEXT values.
In your file, the data in column A is TEXT. To convert it to numbers...
Select the range A2:A269
Goto the Data tab>Text to columns
Click: Finish
The formula is now working!
Yeah I saw that it was text. But you have have quotes in the formulas that you recommended as well haha.
Yes, those expressions get evaluated as text strings:
">4300" and "<=4800"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks