ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   extact data (https://www.excelbanter.com/new-users-excel/262359-extact-data.html)

Hassan
extact data
 
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
1 Attachment(s)
Quote:
Originally Posted by Hassan (Post 948620)
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


All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com