# SUMIF problem

Folks,
I am trying to sum if values from A3:A12 are >=2500 and <5000. See below:
``````sumif(A3:a12>=2500<5000,a3:a12)
``````
###### Who is Participating?

Commented:
Hi fh,

Try SUMIFS instead, lets you specify multiple criteria.
=SUMIFS(A3:A12,A3:A12,">=2500",A3:A12,"<5000")

Matt
0

Author Commented:
Matt,
I need the \$ value - forgot to mention that.
0

Commented:
I'm not sure I understand what you mean. My formula should return the sum of values in your range (a3:a12) which are between 2500 and 4999. Is there a different range that should be summed up?

EDIT: Typo
0

Author Commented:
The value returned from your formula = TRUE. The range is correct. Sum all values >=2500 <5000
0

Author Commented:
OK - I reposted your solution and got the right answer -
0

Author Commented:
Thanks Matt - don't know why it did not work the first time
0

Commented:
I'm a bit puzzled I guess. Do you get the same result with this attached workbook?
fh-sample.xlsx
0

Commented:
Ok, glad it worked. Who knows :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.