SUM

J

jim mcgrath

Hello,
I have 2 columns I want to analyse.
Col. A has (3 digit numerical) codes, & col. B has corresponding numerical
values.
I'm looking for a formula to give me a sum of the values for each code.
Help please.

Jim
 
B

Bob Phillips

=SUMIF(A:A,"code",B:B)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top