Search : in
By :

Excel Formula add data if columns match

Last answer on Sep 4, 2009 7:32:45 pm BST kv, on Sep 4, 2009 6:44:12 pm BST 
 Report this message to moderators

Hello,
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.
Ex:
sheet1: Sheet2:
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
Help Please!!

Configuration: Windows XP Internet Explorer 7.0

Best answers for « Excel Formula add data if columns match » in :
Adding data from one column using another ShowAdding data from one column using another Issue Solution Note Issue I am having a real problem with an Excel formula. I have a worksheet with variable rows and a number of columns. I need to add together the values of particular...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Ask your question Reply

1

 sadgurl, on Sep 4, 2009 7:32:45 pm BST

Well i guess for the first part i should be like this

dim n as interger

for n = 0 to 2
if sheet1.cells(n,0) = Sheet2.cells(0,0) then
Sheet2.Name = "toy"
next
endif

this part take the cells A1 in sheet1 and compare it to the cells in colum a of sheet 2, if the answer is true the sheet is name as toy,

for the rest am sorry but i dont clearly see what you mean

   
Reply to sadgurl
Ask your question Reply
They need your help