SUM IF

[Stella]

I would like to sum values within a certain range located in a separate
worksheet. $50MM Less than $5000 $5K to $10K $10,001 to $25K $25,001 to
$50K Greater than $50K


This formula does not work: Can you correct.

=SUMIF('Data Source $50MM'!B1:B2240,">=5000") -SUMIF('Data Source
$50MM'!B1:B241,"<=10000")

 

[Peo Sjoblom]

=SUMIF('Data Source $50MM'!B1:B2240,">=5000") -SUMIF('Data Source
$50MM'!B1:B241,">10000")

will count from 5000 to 10000


--


Regards,


Peo Sjoblom

 

[JE McGimpsey]

One way:

=SUMIF('Data Source $50MM'!B1:B2240,">=5000") - SUMIF('Data Source
$50MM'!B1:B241,">10000")

(i.e., subtract values >10K from all values >=5K)

Another:

=SUMPRODUCT(--('Data Source $50MM'!B1:B2240>=5000), --('Data Source
$50MM'!B1:B2240<=10000), 'Data Source $50MM'!B1:B2240)

 

[Stella]

I cannot thank you enough. Your quick accurate response is so greatly
appreciated.

 

[Stella]

Can you help me one more time? I need to count the information in the same
ranges, but changing to countif from(sumif) doesn't work.

 

[JE McGimpsey]

What does "doesnt' work" mean? COUNTIF() and SUMIF() should be
interchangeable as long as you have only two arguments.

What formula did you end up using? It would be helpful to reply to
*that* post, rather than the original one.

 

[Stella]

I used the SUMPRODUCT FORMULA BELOW - it worked great to determine Value, but
now I need to count the items.

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--('Data Source $50MM'!B1:B2240>=5000), --('Data Source
$50MM'!B1:B2240<=10000))