Summing a range within a range
 

I need the formula that will sum a range within a range. Example: the primary
range consists of the following numbers: 1,2,3,4,5,6,7,8,9,10 and I need to
know how many numbers are 3 and <8. First I need to know the sum ot the
qualifying numbers; second I need to know how many items there are.

Stumped and exhausted...anyone's help will be greatly appreciated!
--
Need to Know

Summing a range within a range
 

Try these...

For the SUM:

=SUMIF(A1:A10,"3")-SUMIF(A1:A10,"=8")

For the COUNT:

=COUNTIF(A1:A10,"3")-COUNTIF(A1:A10,"=8")

--
Biff
Microsoft Excel MVP


"arlum" wrote in message
...
I need the formula that will sum a range within a range. Example: the
primary
range consists of the following numbers: 1,2,3,4,5,6,7,8,9,10 and I need
to
know how many numbers are 3 and <8. First I need to know the sum ot the
qualifying numbers; second I need to know how many items there are.

Stumped and exhausted...anyone's help will be greatly appreciated!
--
Need to Know

Summing a range within a range
 

Hi,
to sum use

=SUMPRODUCT(--(A1:A103),--(A1:A10<8),A1:A10)

to count

=SUMPRODUCT(--(A1:A103),--(A1:A10<8))

change range to fit your needs

if this helps please click yes thanks


"arlum" wrote:

I need the formula that will sum a range within a range. Example: the primary
range consists of the following numbers: 1,2,3,4,5,6,7,8,9,10 and I need to
know how many numbers are 3 and <8. First I need to know the sum ot the
qualifying numbers; second I need to know how many items there are.

Stumped and exhausted...anyone's help will be greatly appreciated!
--
Need to Know

Summing a range within a range
 

I've already answered in your other post

"arlum" wrote:

I need the formula that will sum a range within a range. Example: the primary
range consists of the following numbers: 1,2,3,4,5,6,7,8,9,10 and I need to
know how many numbers are 3 and <8. First I need to know the sum ot the
qualifying numbers; second I need to know how many items there are.

Stumped and exhausted...anyone's help will be greatly appreciated!
--
Need to Know