Return number of cells filled

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Hi Guys,

Excel 2000. I have Cells B2 thru G2 available to be filled in with either a
1 or 0. Some of the cells are blank. I want to put a formula in cell H2
that will return the total cells that are filled in. Right now B2 has a 1
and C2 has a 0. I want H2 to return the number 2 or if it's possible 2/6
would be even better.

Thanks,
Linda
 
Worked great! How about a %, can it convert to a percent too? I tried
changing the properties but that didn't work, I'll keep clicking...

Thanks,
Linda
 
Back
Top