# Sum 6 separate columns of numbers that correspond to the same ID number in column A.

Column A contains postcode numbers. Column B contains suburb names where different suburb names may correspond to the same postcode number.
Columns C, E, G, I. K and M may contain vales. The objective is to sum these values where they correspond with the same postcode number in column A as per examples in Columns D, F, H, J, L and N.
Postcode-collation-example1.xlsx
Asked:
###### Who is Participating?

IT Services ConsultantCommented:
Hi,

Hmmm...

Unless I have misunderstood the requirements, I would suggest this formula in cell [D3]:

=IF(COUNTIF(A3:A\$3123,A3)=1,SUMIF(A\$3:A\$3123,A3,C\$3:C\$3123),"")

Then copy that down column [D] until you reach cell [D3123].

I have attached a workbook with suitable formulae in the other columns.

BFN,

fp.
Q-28138893.xlsx
0

EngineerCommented:
Copy this in D3 and copy down and then across

=IF(COUNTIF(\$A:\$B,\$A3)=COUNTIF(\$A3:\$A3,\$A3),SUMIF(\$A:\$B,\$A3,\$C:\$E),"")
0

Author Commented:
Thanks ssaqibh.

But it doesn't appear to sum where there are multiple postcodes.

Can you attach the file?

Thanks again,

Greg
0

Author Commented:
Perfect!! Thanks heaps.  Not sure what I did wrong but the file is perfect.
0

IT Services ConsultantCommented:
You're very welcome.

I don't think you did anything 'wrong'

The first suggestion was not correct & did not address your requirements.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

## Already a member? Login.

All Courses

From novice to tech pro — start learning today.