I have a list of sales in an Excel file with vendor name and article price. This list is on one page, now I want to display the sum of all the sales by one person on a second page.
I have tried to vertical search for "name" in columns A to F on page 1
but that stops and shows the first result it sees, but not all the sales by that person.
I tried to stick that same formula in
=sum() but I never had any hope that would work really.
So my question would be, is there a way to search a column for a certain name and add up all the sales in the second column with that same name and display that on a second page.