Easiest to just illustrate what I'm trying to do:
Start with this:
Alfredo Roca ‘Dedication’ Bonarda 5
Alfredo Roca ‘Dedication’ Bonarda 13
Alfredo Roca ‘Dedication’ Sauvignon Blanc 8
Alfredo Roca Chardonnay 5
Alfredo Roca Chardonnay 16
End with this:
Alfredo Roca ‘Dedication’ Bonarda 18
Alfredo Roca ‘Dedication’ Sauvignon Blanc 8
Alfredo Roca Chardonnay 21
So, For rows where the text in column A is identical,
step 1 - sum up the their respective column B values
step 2 - write a single row with the text in column A, and the sum in column B.
All duplicate rows are deleted.
Any fast way to do this? I know about SUMIF but it's too many entries to do with multiple sumif's.
Bookmarks