muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hello everybody,
i have some "SUM" formula and looking for some "COUNT" formula
here is some code :
i have some "SUM" formula and looking for some "COUNT" formula
here is some code :
Code:
[COLOR=#333333]=SUMPRODUCT(($A$2:$A$7=$A12)*($B$2:$B$7=$B12)*($F$2:$F$7=D$11),INDEX($C$2:$E$7,0,MATCH($C12,$C$1:$E$1,0)))[/COLOR][CODE]
how to modify formula above with to be "count" formula?
guys...thanks very much....
m.susanto