Don't show a zero value: =IF(F8=0,"",E8/F8)

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Hello,

1) In the subj I've learned to make a cell blank if the answer is 0. I'm
trying to do the same with the following equation and I keep getting
circular refs... I plainly just don't know how to do it.... :-(

=SUM(E7:E125)+SUM(COUNTIF(E7:E125,"S")+COUNTIF(E7:E125,"SH")+COUNTIF(E7:E125
,"SK")+COUNTIF(E7:E125,"C"))/SUM($A$126)*100

2) Also, I was just thinking, all the countif's I have, can I combine them
into one COUNTIF(E7:E125,"S""SH""SK"....) I'll give it a shot too...

Thank you,
Kevin
 
Hi
try
=SUM(E7:E125)+SUMPRODUCT(--(E7:E125={"S","SH","C"}))/SUM($A$126)*100

an to prevent a zero try
=IF(SUM(E7:E125)+SUMPRODUCT(--(E7:E125={"S","SH","C"}))/SUM($A$126)*100
,SUM(E7:E125)+SUMPRODUCT(--(E7:E125={"S","SH","C"}))/SUM($A$126)*100,""
)
 
Frank,
Thanks... worked like a charm...

Kev

Frank Kabel said:
Hi
try
=SUM(E7:E125)+SUMPRODUCT(--(E7:E125={"S","SH","C"}))/SUM($A$126)*100

an to prevent a zero try
=IF(SUM(E7:E125)+SUMPRODUCT(--(E7:E125={"S","SH","C"}))/SUM($A$126)*100
,SUM(E7:E125)+SUMPRODUCT(--(E7:E125={"S","SH","C"}))/SUM($A$126)*100,""
)
Click to expand...
 
Back
Top