Function help?????

[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.....

 

[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)