• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

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
0
swjtx99
Asked:
swjtx99
1 Solution
 
Rgonzo1971Commented:
Hi,

greater than is >

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

Open in new window


Regards
0
 
Ken ButtersCommented:
Try this :

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


This should concatenate the less than with the value in B5 to resolve to your sum criteria.
0
 
swjtx99Author Commented:
Thanks Ken,

Works great!

Regards,

swjtx99
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now