Return number of cells filled

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
 
L

LMB

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top