I need to compare one column of numerical data on one worksheet with another column in a different worksheet. Then, where the numbers are the same I need the corresponding numbers from a third column totalling.
Eg
Sheet1..........Sheet2
Col A...........Col A.....Col B
(If the contents of the range of cells in column A of Sheet 1 equal the contents of the range of cells in column A of Sheet 2 - then sum all the corresponding cells in column B of sheet 2)
Any ideas would be greatly appreciated.
Eg
Sheet1..........Sheet2
Col A...........Col A.....Col B
(If the contents of the range of cells in column A of Sheet 1 equal the contents of the range of cells in column A of Sheet 2 - then sum all the corresponding cells in column B of sheet 2)
Any ideas would be greatly appreciated.