Sum Between Values Within The Same Range

[msiyab]

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

[alansidman]

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.

[msiyab]

I want the sum of the values in each category.

[alansidman]

See attached worksheet example

[p45cal]

See attached worksheet exampleA slight tweak to C6's formula from

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

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

[alansidman]

@p45cal

Thanks for finding and fixing that.

Alan