Excel add amounts that meet criteria
I have a workbook with two sheets (sheet 1 and sheet 2). On sheet 1 I have company names in column A. The names only appear once. On sheet 2 column A, I also have company names and the company names can appear more then once.
I need a formula in sheet 1 column b that looks at sheet 2 and matches the company name in column a. If the name mach, add the amounts from sheet 2 column S to sheet 1 column b.
I need a formula in sheet 1 column b that looks at sheet 2 and matches the company name in column a. If the name mach, add the amounts from sheet 2 column S to sheet 1 column b.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much.
You're welcome!
ASKER
Sheet 1 Column A Column B Sheet 2 Column A Column S
Company1 Company1 10
Company1 40
Company2 10
WHANT
Sheet 1 Column A Column B
Company1 50