Hi

I have issue with Countif function.

I have following formula in E10 cell

=IF(COUNTIF(G10:V10,$E$4)=0,"",COUNTIF(G10:V10,$E$4))

and following in F10 cell

=IF(COUNTIF(G10:V10,$F$4)=0,"",COUNTIF(G10:V10,$F$4))

I am trying to add the value together form cell E10&F10 into cell D10, BUT it produces #VA:UE!.

All i am trying to do is not to display ZERO in Countif formula and add to cell together.

PLEASE CAN SOMEONE HELP ME.

Regards