Solved

Sumif value greater than value in another cell

Posted on 2014-03-13
3
320 Views
Last Modified: 2014-03-13
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
Comment
Question by:swjtx99
3 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 39926984
Hi,

greater than is >

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

Open in new window


Regards
0
 
LVL 19

Accepted Solution

by:
Ken Butters earned 500 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

by:swjtx99
ID: 39927041
Thanks Ken,

Works great!

Regards,

swjtx99
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Cloud-based technologies and services will continue to grow in popularity in 2017 thanks to the simple, scalable and cost-effective solutions they deliver. Here are three areas where cloud adoption is poised to really take off.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.
Video by: Zack
Viewers will learn the basics of using Excel Tables, the benefits found with them, and some pitfalls.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now