One way:

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


In article ,
Stella wrote:

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

"JE McGimpsey" wrote:

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)


In article ,
Stella wrote:

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