?
Solved

Sumif value greater than value in another cell

Posted on 2014-03-13
3
Medium Priority
?
326 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
[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
  • Learn & ask questions
3 Comments
 
LVL 52

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

by:swjtx99
ID: 39927041
Thanks Ken,

Works great!

Regards,

swjtx99
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

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.

771 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