This is perfect! Thank you SO much!!!

"Ron Coderre" wrote:

Try this:

=SUMPRODUCT((A1:A1000=81500)*(B1:B1000=1885)*(C1:C 1000529999)*(C1:C1000<539999)*(D1:D1000)

Adjust range references to suit your situation (SUMPRODUCT won't work on
whole columns)

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"GfaCS" wrote in message
...
I'm trying to create a formula that says "if column a=81500 AND if column
b=1885, then do a sumif(columnC,"<529999","539999",columnD).

So, basically, I want to do a sumif function but put restrictions on it
and
only add up those numbers in column D that meet the criteria.

To make things more difficult, I'd like the sumif funtion to lookup a
range
of numbers (ie: 530000 thru 539999) vs. a single number in column C and
return the total of everything that matches that range from column D.

Any suggestions?