Is there any Easy way to keep #DIV/0! from appearing in cells when there is no matching data to calculate in a formula?
Here's an example of the formula that I'm using...
=SUMIF('Main Sheet'!$Q$7:$Q$176,"In-HouseWonderBall",'Main Sheet'!$I$7:$I$176)/SUMIF('Main Sheet'!$Q$7:$Q$176,"In-HouseWonderBall",'Main Sheet'!$H$7:HH$176)
Again... if there's an easy solution that I can apply to all cells.
THANK YOU!!!!!
Here's an example of the formula that I'm using...
=SUMIF('Main Sheet'!$Q$7:$Q$176,"In-HouseWonderBall",'Main Sheet'!$I$7:$I$176)/SUMIF('Main Sheet'!$Q$7:$Q$176,"In-HouseWonderBall",'Main Sheet'!$H$7:HH$176)
Again... if there's an easy solution that I can apply to all cells.
THANK YOU!!!!!