extact data

[Hassan]

Dear All,

I have 30 sheets, which contains the count of SMS of everyday, I need
summary on last sheet that every sim consumed how many SMS. The count is in
accending order so Sim no. will not be in order,

Thanks & Regards

TFMR

 

[bala_vb]

Dear All,

I have 30 sheets, which contains the count of SMS of everyday, I need
summary on last sheet that every sim consumed how many SMS. The coun
is in
accending order so Sim no. will not be in order,

Thanks & Regards

TFMR

Hi Hassan,

There are two options,

#1. using sum(vlookup from sheet1 + vlookup from sheet2 +......vlooku
from sheet3)
sample workbook attached

#2. arrange all the sim number in sheet1 to sheet2 in ascending orde
and in total worksheet just use th
sum(sheet1!A2,Sheet2!A2,sheet3!A3......,sheet30!A2)...

Thanks
Bal

+-------------------------------------------------------------------
|Filename: Option1.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=135
+-------------------------------------------------------------------