Simplifying/speeding up this formula
Use 2 cells The first for the sumproduct the second for the if
--
Gary''s Student - gsnu200737
"Keith R" wrote:
Is there a way to change the following formula from
=if(calculation result 0, calculate it again, "") to =if(calculation result
0, use that result, "") ?
=IF(SUMPRODUCT(('Raw Data'!$A$2:$A$30000=$C5)*1,('Raw
Data'!$B$2:$B$30000=I$1)*1)0,SUMPRODUCT(('Raw
Data'!$A$2:$A$30000=$C5)*1,('Raw Data'!$B$2:$B$30000=I$1)*1),"")
Just thinking if there is a clever way to do this, it would cut worksheet
calculation time in half...but I'm not sure how Excel calculates and stores
this data, so my assuption may be incorrect anyway...
Thanks,
Keith
|