muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
i have dozen sheets, i want to sum data from multiple sheets. My position data always in cell C20 for each sheet.
my data contains string, mark =, space (in front mark=), mark . or ,
how to do it this:
here my data
any help, thanks all..
note :
can use formula or macro
.sst
i have dozen sheets, i want to sum data from multiple sheets. My position data always in cell C20 for each sheet.
my data contains string, mark =, space (in front mark=), mark . or ,
how to do it this:
here my data
LPK-2.010 All.xlsx | |||
---|---|---|---|
G | |||
2 | data | ||
3 | = 877.000,00 | ||
4 | = 1.200.000,00 | ||
5 | = 10.877.000,00 | ||
6 | = 115.877.000,00 | ||
7 | = 1.877.500.000,00 | ||
8 | = 10.900.600.000,00 | ||
9 | = 123.300.400.000,00 | ||
10 | sum?? | ||
Sheet1 |
any help, thanks all..
note :
can use formula or macro
.sst