muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
how to make formula contains Sumproduct,Abs, Subtotal..
i want to summing absolut number using Sumproduct but in visible cell.
here layout
i try =sumproduct(abs(subtotal(109,.....) not work
note ;
don't use array function
thank in advance.
.sst
how to make formula contains Sumproduct,Abs, Subtotal..
i want to summing absolut number using Sumproduct but in visible cell.
here layout
Book1 | ||||
---|---|---|---|---|
I | J | |||
2 | data | |||
4 | -3 | |||
6 | 4 | hiden row | ||
7 | 5 | |||
8 | 8 | sum absolut | ||
Sheet1 |
i try =sumproduct(abs(subtotal(109,.....) not work
note ;
don't use array function
thank in advance.
.sst