Sumif value greater than value in another cell

I am using =SUMIF(D4:D1115,"<700")

What I want to do is have the value 700 in another cell.

I tried =SUMIF(D4:D1115,"<B5") and put 700 in B5 but it returns zero.

Also tried a lot of other variations/syntax and Google hasn't been helpful

Thanks in advance

swjtx99
swjtx99Asked:
Who is Participating?
 
Ken ButtersConnect With a Mentor Commented:
Try this :

=SUMIF(D4:D1115,"<"&B5)


This should concatenate the less than with the value in B5 to resolve to your sum criteria.
0
 
Rgonzo1971Commented:
Hi,

greater than is >

=SUMIF(D4:D1115,">700")

Open in new window


Regards
0
 
swjtx99Author Commented:
Thanks Ken,

Works great!

Regards,

swjtx99
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.

All Courses

From novice to tech pro — start learning today.