When there is no entry in E for the following formula, I am getting the #VALUE! return in the formula cell:
=IF(Q244=0,"",SUMIF($E$18:$E$258,E244,$D$18:$D$258))/Q244
The best result would be an empty cell for the formula cell if there is no E...better than a 0...
Thanks
=IF(Q244=0,"",SUMIF($E$18:$E$258,E244,$D$18:$D$258))/Q244
The best result would be an empty cell for the formula cell if there is no E...better than a 0...
Thanks