Function help?????

J

Jay

Can someone assist in getting this function to return a 0 if there is no
value in the referenced cells?

=SUMIF($C$5:$CI$5,"FSV AS*",C27:CI27)/R30

Thanks, in advance.....
 
F

Frank Kabel

Hi
do you mean cell R30?
If yes, try:
=IF(R30=0,0,SUMIF($C$5:$CI$5,"FSV AS*",C27:CI27)/R30)
 
Top