add dollar amounts between two ranges 1

[akira04]

I have a database in which I would like to calculate dollar amounts between particular dollar ranges,

So far I am using the following formula to count how many entries are at within each range,

=SUMPRODUCT(('all workinglist'!G$2:G$2087>=500000)*('all workinglist'!G$2:G$2087<=749999))

Doller Ranges
$750000-$999999 1 entry
$500000-$749999 2 entries
$250000-$499999 4 entries

but I would like to add these dollar amounts together.

I've tried many different formulas such as:
=SUMIF('all workinglist'!G$2:G$2087,">=750000,<=999999")

But I can't get it to work!
Please advise,
HB

 

[SkipVought]

Hi,

You need a table like this...
[tt]
$750000
$999999
$500000
$749999
$250000
$499999
[/tt]


Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[akira04]

my apologies if I I didn't explain clearly.

what I really need is a simple formula that will add numbers within a given range for instance-

sum(range between >=100 and <=250) etc.

I can seem to find this solution anywhere.

 

[SkipVought]

Sum What? The values in the table?

Use SumIf

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[akira04]

I tried SUMIF(see my first post) but I couldn't get it to go-

Lets say I have a table with unsorted dollar amounts like so:

$12542
$50000
$1254
$5122
$4521
$2541
$1525

I would like a formula that will look at this range and add the total of any dollar amounts between $1000 and $5000-

HB

 

[SkipVought]

[tt]
=SUMPRODUCT(($A$1:$A$7<5000)*($A$1:$A$7>2000)*(A1:A7))
[/tt]

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}