How to SUM parts of a column which have same text value in different column in the same row

excel if-statement excel-formula sum pivot-table
user2285265 picture user2285265 · Oct 29, 2013 · Viewed 200k times · Source

I have a column with names and a column with numbers: 

FirstName    Name    Number
John         Smith     17
John         Smith     26
Peter        Smith     116
Peter        Smith     25
Franck       Black     17
Luke        Peterson   17
Luke        Peterson   37

Names with same FirstName and Name represent the same person. I need to sum the numbers associated with them. I prefer not to use VBA.

Answer

pnuts picture pnuts · Oct 29, 2013

A PivotTable might suit, though I am not quite certain of the layout of your data:

SO19669814 example

The bold numbers (one of each pair of duplicates) need not be shown as the field does not have to be subtotalled eg:

SO19669814 second example

Related questions

If two cells match, return value from third

Here's a simple explanation of what I'm having trouble with. Column A: List of 2300 order numbers Column B: Email Address associated with an order number Column C: List of 100 specific order numbers that I need the email address for So, …

Read More
PivotTable to show values, not sum of values

I'm wanting to display a pivot table and for it to show me the actual values, one on each row, rather than a sum of the values. E.g. Name Jan Feb Mar Apr Bob 12 10 4 3 5 James 2 6 8 1 15 etc. My starting point …

Read More
Excel formula to search if all cells in a range read "True", if not, then show "False"

Using an excel formula to search if all cells in a range read "True", if not, then show "False" For example: A B C D True True True True True True FALSE True I want a formula to read this …

Read More