ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SUM (https://www.excelbanter.com/excel-discussion-misc-queries/115759-sum.html)

jim mcgrath

SUM

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

Gary''s Student

SUM

You should consider using a Pivot Table:

http://www.contextures.com/xlPivot07.html#Unique

--
Gary's Student

"jim mcgrath" wrote:

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

Bob Phillips

SUM

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

--
HTH

Bob Phillips

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

"jim mcgrath" wrote in message
...
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

All times are GMT +1. The time now is 09:49 PM.