Formula help!!!
"Max" wrote...
....
2. An alternative is to use a simple IF** construct, eg:
=IF(SUMPRODUCT(($I$10:$I$20=C$1)*($H$10:$H$20=$A2 ))=0,"",
SUMPRODUCT(($I$10:$I$20=C$1)*($H$10:$H$20=$A2)) )
**the downside is this will increase the calc load . . .
"OKY" wrote in message
....
I noticed that on the cells where nothing is entered a zero shows up....
....
Looks like all that needs testing is whether there's anything in H10:I20, so
all that may take is
=IF(COUNTA($H$10:$I$20),SUMPRODUCT(($I$10:$I$20=C$ 1)*($H$10:$H$20=$A2)),"")
which should have much less impact on recalc speed.
|