I am basic excel user who is slowly needing to use formulas. I have two seperate charts that I've put into 2 worksheets with similar information. Some of the rows will be the same and if they are I need to add the data.
A B C D A B C D
1 Bat 2 0 3 1 Toy 3 1 2
2 Car 1 6 0 2 Owl 0 5 3
3 Toy 3 9 4 3 Bat 6 5 0
Soy what I need the formula to do is: If A1 (sheet 2) Matches any cell on column A (Sheet1) then label it 'Toy' and add the following cells for a total B1(s 2) + B3(s1), C1+C3,D1+D3. Final Result: A B C D
1 Toy 6 10 6
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com,http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like