D
DogEatDog World
I got one excel book and I was very intriegued by use of sumprod function
=+SUMPRODUCT(--($C$8:$C$109="A");--(D$8
$109>0))
Now I need to use it so I would like to know what does it do(in general)
In example above it finds in range $C$8:$C$109 cells that have "A" gives
them value 1 and multiplies with corresponding cell in range D$8$109>0
which it also gives value 1. Is it possible that all that is done with just a
-. When I click at the formula it doesn't show explanation for that only for
sumprod
=+SUMPRODUCT(--($C$8:$C$109="A");--(D$8
$109>0))Now I need to use it so I would like to know what does it do(in general)
In example above it finds in range $C$8:$C$109 cells that have "A" gives
them value 1 and multiplies with corresponding cell in range D$8
$109>0which it also gives value 1. Is it possible that all that is done with just a
-. When I click at the formula it doesn't show explanation for that only for
sumprod