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

Hi Hassan,

There are two options,

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

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

Thanks
Bala