Bob Phillips wrote:
=SUMIF(A:A,"value",B:B)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Oscar" wrote in message
ups.com...
I wish to sum cells in a column according to category in an
adjacent
column