I'm hoping someone can assist me with this. I have a column (C) which contains multiple account #'s 30,000 plus. There could be multiple duplicate account #'s but the same account #'s will be together (i.e. c6,c7,c8, etc) until a different account # appears in column C (i.e. c9,c10,11, etc). In column (H) there is a usage # which will be affiliated to each account number. I need to figure a formula which will identifiy all of the matching account #'s in column "C", then for that particular account # add all of the affiliated numbers in column "H" for a total. This needs to be repeated for all of the individual account #'s in column "C". Any suggestions would be greatly appreciated!
In my example I color coded two separate accounts as an example for both column c & h. I need to total the numbers in "H" for each account. I hope this makes sense! Thanks in advance!!
Bookmarks