Sum Between Values Within The Same Range

**msiyab** · 02-13-2014, 06:45 PM

I want the sum of the values in each category.

**alansidman** · 02-14-2014, 09:36 AM

See attached worksheet example

**p45cal** · 02-15-2014, 11:03 PM

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")

**alansidman** · 02-17-2014, 12:30 AM

@p45cal

Thanks for finding and fixing that.

Alan

Thread: Sum Between Values Within The Same Range