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.


In article ,
Stella wrote:

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.

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