Sum Between Values Within The Same Range

Hi Guys,

I have an excel list of Magazine quantities in Cell C. The list includes numbers from 1 to 1000. This list has repeating values too, that is 1 is present multiple times in the same list and so on.

I need a formula to sum the following:
Sum of all magazines with the quantity value of 1's
Sum of all magazines with the quantity value between 2's & 9's (2's & 9's should be included too)
Sum of all magazines with the quantity value between 10's & 24's (10's & 24's should be included too)
Sum of all magazines with the quantity value between 25's & 49's (25's & 49's should be included too)
Sum of all magazines with the quantity value between 50's & 99's (50's & 99's should be included too)
Sum of all magazines with the quantity value greater than 100's (100 also to be included)


Thanks,
Siyab

You have used the term Sum. Does this mean you want to sum the values in Column c for each of the characteristics or you want a count of Column c for each of the characteristics. This is unclear in your request.

I want the sum of the values in each category.

See attached worksheet example

Quote:

---

Originally Posted by alansidman

See attached worksheet example

---

A slight tweak to C6's formula from

Code:

---

=SUMIFS($C$2:$C$1001,$C$2:$C$1001,">51",$C$2:$C$1001,"<100")

---

to

Code:

---

=SUMIFS($C$2:$C$1001,$C$2:$C$1001,">49",$C$2:$C$1001,"<100")

---

@p45cal

Thanks for finding and fixing that.

Alan