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