I have 6 sheet -- sheet 1, 2, 3, 4, 5, are fill with data and to be generated in sheet 6.
Eg:- sheet1:- column a column b column c column d column e
a----------201---------251-------252--------52
c----------611---------231-------362--------42
g----------871---------651-------452--------87
f----------541---------321-------932--------65
d----------012---------325--------772--------31
b----------325---------465--------652--------99
e----------201---------010--------452--------46
same table are in sheet 2, 3, 4 ,5.
I want to calculate in sheet6, is it should look "a" how many time it has occurred in sheet 1 to 5 and then then plus column b from sheet
1 to 5 and then then plus column c from sheet1 to 5 and then then plus column d from sheet1 to 5 and then then plus column e from sheet
1 to 5.
Can i get formula for this if any one please help.