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