# Add partial column depending on name in cells.

1. ## Add partial column depending on name in cells.

I am trying to find a way to add numbers from cells in col 2 and col 3 when the name in col 1 is the same. I want to put the totals in col 5 and 6 on the lowest row with the same name. I attached a file as an example of what I have and I hope I explained my problem so it is understandable.

Larry

2. ## Re: Add partial column depending on name in cells.

Please find the file attach and hope the best......

regards

3. ## Re: Add partial column depending on name in cells.

Or with a pivot table.

See the attached file.

4. ## Re: Add partial column depending on name in cells.

Azumi, that was a nice way of selecting the rows that need to be completed!! Can the SUMPRODUCT not be simplified to

=IF(COUNTIF(\$A\$2:\$A\$20,\$A2)=COUNTIF(\$A\$2:\$A2,\$A2),SUMPRODUCT((\$A\$2:\$A\$20=\$A2)*(B\$2:B\$20)),"")

5. ## Re: Add partial column depending on name in cells.

Originally Posted by Glenn Kennedy
Azumi, that was a nice way of selecting the rows that need to be completed!! Can the SUMPRODUCT not be simplified to

=IF(COUNTIF(\$A\$2:\$A\$20,\$A2)=COUNTIF(\$A\$2:\$A2,\$A2),SUMPRODUCT((\$A\$2:\$A\$20=\$A2)*(B\$2:B\$20)),"")
You're right thanks Glenn

6. ## Re: Add partial column depending on name in cells.

oeldere, thank you, I looked at your attachment and it looks like what I want. I will now read up on pivot tables.

Thanks also to the others who replied and tried to help me. I am too new to understand most of what is being said in here but I am learning.

7. ## Re: Add partial column depending on name in cells.

You're welcome. We appreciate the feedback!

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

If you have other questions on this item, just ask.

8. ## Re: Add partial column depending on name in cells.

I have been playing around with the pivot table option. I have learned some things but so far I have not learned how to add the column with the totals next to the columns that I already have. I did learn how to make a sheet with only totals next to the names. This will help me a lot. But I will keep working on this for a while to see if I can grasp more of how it works. My next problem is to find out if I can have a sheet with a blank pivot table that will import the data and be in the same format as the table I created.

Thanks again.

9. ## Re: Add partial column depending on name in cells.

Enter this in D2 and fill across and down:
Formula:
`Please Login or Register  to view this content.`

10. ## Re: Add partial column depending on name in cells.

Fill in the data in the table on Sheet2 then refresh the Pivot table on Sheet3.

11. ## Re: Add partial column depending on name in cells.

And to refresh the data (in #10)

Excel 2013 => data = refresh

If you want explaination on the pivot table, just ask.

12. ## Re: Add partial column depending on name in cells.

Yes I must ask. What is a partial column? How do you add it? It may not be worth your time to try to explain all of this. Sorry for not understanding.

Larry

13. ## Re: Add partial column depending on name in cells.

A partial column has no meaning for Excel - it's the term that YOU used to describe what you wanted. The contributions that have been made fall into two types: those that tried to reproduce the FORMAT of your desired result (e.g. Azumi & myself) and those that tried to reproduce the INFORMATION that you wanted in a different format (Oeldere). Did you look at the solutionsoffered at Posts 2 and 4. Do they not match exactly what you had asked for in Post 1?

Comment for NDM: I had tried that earlier, but if (e.g.) Jones reoccurrs later on in the listing, it all goes pear-shaped...

14. ## Re: Add partial column depending on name in cells.

Since you have answers from several members, it is usefull to add to whom or to what # you are replying

If you reply to me, I don't understand the question, so in that case you have to explain once again (better).

15. ## Re: Add partial column depending on name in cells.

Upload a workbook with the results that you want manually entered. Your column terminology is impossible to follow as it isn't used in Excel. You have several answers but no real response as to what is addressing your problem.

16. ## Re: Add partial column depending on name in cells.

It seems I am not even asking the questions in a way that makes sense to the experts here. I also screwed up when I titled my first post, I did not mean partial column I meant additional column. And then I did not realize it was me that started the "partial column" thing. Sorry.

I looked over the answers and saw that azumi put a file on here that did what I wanted. But without an explanation of how he made the file I did not understand how I could duplicate it. Unless the formulas have to be redone every time the frequency of a name changes in column 1.

oeldere got me to looking at pivot tables and that seems to be where I need to go. I have been trying to learn about them and slowly making progress. I am sorry if I do not speak the language but it will eventually sink in.

I have progresses quite a bit in understanding pivot tables. I want to thank all who have posted here with your ideas to help me.

I am going to go forward with the pivot tables until I understand them well enough to do what I want.

Thanks you, one and all
Larry

17. ## Re: Add partial column depending on name in cells.

@Larry Ryan

I realy appreciate that.

18. ## Re: Add partial column depending on name in cells.

@Larry Ryan
Take a look at the 2 solutions that I gave you in msg #10.

I have given you a formula driven solution on Sheet1 and sheets 2 and 3 have a blank table that when filled out will populate the pivot table when you right click in the pivot table and choose refresh.

19. ## Re: Add partial column depending on name in cells.

This is updated from my previous file.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1