Hello,
New to this forum. I am trying to figure out a formula to add specific value together from a column. example large column of different numbers but I want to add a total of all the number that are equal to 10 or less together, not how many are that value , but the total of those values , Or a greater then 10.1 but less then 20.1 totals. Any help would be appreciated as my head is ready to pop. Mark
Try the SUMIF function. Something like this:
=SUMIF(A:A,"<=10")add a total of all the number that are equal to 10 or less
=SUMIFS(A:A,A:A,">10.1",A:A,"<20.1")greater then 10.1 but less then 20.1
Last edited by 63falcondude; 06-09-2017 at 12:10 PM.
thanks man, blood pressure back to normal.
Mark
You're welcome. Happy to help.
If this solved your issue, please mark this thread as SOLVED.
Spoke to soon. What is wrong =SUMIFS(G2:G25,G2:G25,">10.1",G2:G25,"<20.1")
This formula will sum the values in the range G2:G25 that are greater than 10.1 and less than 20.1.Originally Posted by Mark59
Is this producing an unexpected result?
Last edited by 63falcondude; 06-09-2017 at 12:42 PM.
I guess this formula is short of an equal sign.
=SUMIFS(G2:G25,G2:G25,">=10.1",G2:G25,"<20.1")
yep, Problem solved. Not sure how to mark the thread solved?
Thank you all for the help
How to mark a thread SOLVED: https://www.excelforum.com/faq.php
Last edited by 63falcondude; 06-09-2017 at 01:36 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks