Hi

You need to use 2 Sumif's taking away the values included in the lower
section

=SUMIF(A:A,"<1000",C:C)-SUMIF(A:A,"<500",C:C)


--
Regards

Roger Govier


"b1888" wrote in message
ups.com...
Hi Roger,

thats great thanks!

just one further question - if I now want to do the same with anything
between 500 - 999 how do I tell the formula to look between 500 - 999
rather than just <1000 as I want to exclude anything lower than 500.

Thanks again,

B


Roger Govier wrote:

Hi

One way
=SUMIF(A:A,"<500",C:C)

--
Regards

Roger Govier