What formula can I use that will take the sum of data on sheet 2 and place it on sheet 1 if a criteria is met?
For example, I want a sum of ABC Company's revenue pulled from sheet 2 and have the sum placed on sheet 1 in the row for ABC Company, and the same for XYZ Company.
Sheet 1
Company | Revenue |
ABC Company |
|
XYZ Company |
|
Sheet 2
Customer | Revenue |
ABC Company | $24,030.00 |
ABC Company | $1,105.00 |
ABC Company | $0.00 |
ABC Company | $28,080.00 |
ABC Company | $0.00 |
ABC Company | $1,104.00 |
ABC Company | $1,250.00 |
ABC Company | $0.00 |
XY Z Company | $1,380.00 |
XY Z Company | $4,120.00 |
XY Z Company | $304.00 |
XY Z Company | $353.00 |
XY Z Company | $420.00 |
XY Z Company | $183.00 |