[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel sum to exclude higher value

Posted on 2013-01-04
1
Medium Priority
?
376 Views
Last Modified: 2013-01-05
Hi Could someone help me with a formula to sum a column but only to add the values under a certain amount e.g. less than 5000?

Best
0
Comment
Question by:DuncanRL
1 Comment
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 1500 total points
ID: 38746408
Hi,
the formula is:
=SUMIF(B:B;"<5000")

Open in new window

where your values to check and to sum are in column B.

HTH
Rainer
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

865 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