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
gregfthompsonAsked:
Who is Participating?
 
[ fanpages ]Connect With a Mentor 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
 
Saqib Husain, SyedEngineerCommented:
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
 
gregfthompsonAuthor Commented:
Thanks ssaqibh.

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

Can you attach the file?

Thanks again,

Greg
0
 
gregfthompsonAuthor Commented:
Perfect!! Thanks heaps.  Not sure what I did wrong but the file is perfect.
0
 
[ fanpages ]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.

All Courses

From novice to tech pro — start learning today.