Excel formula - help needed!
=SUMIF(A:A,"<100",C:C)-SUMIF(A:A,"<500",C:C)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"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
|