Solved

# Sumif value greater than value in another cell

Posted on 2014-03-13
Medium Priority
326 Views
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

swjtx99
0
Question by:swjtx99
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 52

Expert Comment

ID: 39926984
Hi,

greater than is >

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

Regards
0

LVL 19

Accepted Solution

Ken Butters earned 2000 total points
ID: 39926996
Try this :

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

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

Author Closing Comment

ID: 39927041
Thanks Ken,

Works great!

Regards,

swjtx99
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micrâ€¦
Viewers will learn how to apply various conditional formatting in Excel 2013.
Viewers will learn what comprises a theme in Excel 2013, as well as how to customize them.
###### Suggested Courses
Course of the Month14 days, 22 hours left to enroll