add numbers if they meet criteria...?

  • Thread starter Thread starter Dan B
  • Start date Start date
D

Dan B

Hi,

I have a column of numbers. I need a formula that will look at the whole
range and add up only the numbers that are 50 or less. Then I need another
formula that will add them if they are 51 or more.

Thanks for the help.
 
Try something like this:

Sum of the numbers less than or equal to 50
=SUMIF(A1:A100,"<=50",A1:A100)

Sum of the numbers greater than 50
=SUMIF(A1:A100,">50",A1:A100)

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Yep, it helps a ton. Thank You!

Ron Coderre said:
Try something like this:

Sum of the numbers less than or equal to 50
=SUMIF(A1:A100,"<=50",A1:A100)

Sum of the numbers greater than 50
=SUMIF(A1:A100,">50",A1:A100)

Does that help?
***********
Regards,
Ron

XL2002, WinXP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct? 3
if meets criteria add 1 2
Counting Multiple Records by specific criteria 5
Add number before text that matches criteria 3
Calculate total by row number 4
Retrieve unique items with 2 criteria (USING SUMPRODUCT) 5
Excel How to add numbers in same cell? 2
Find the lowest4 numbers of the last 6 in a range 8

Back
Top