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

will count from 5000 to 10000


--


Regards,


Peo Sjoblom




"Stella" wrote in message
...
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")