sum number of x's????

  • Thread starter Thread starter Josh Ashcraft
  • Start date Start date
J

Josh Ashcraft

I have a worksheet with 31 columns which are the days in
december. each column will have an "x" in the cell if
information was submitted that day. now, since some of the
columns will be empty, is it possible to have a function
that will tell me how many of those columns have x's, and
have that number display in another column with a fraction?
ex. user1 submits 22/32 days in december( and 22 of the
days have x's in their columns), and I want it to
display "22/32 days" in another column in the same
worksheet. If someone could help, it would be much
appreciated!
thanks,
Josh
 
use =countif(range for column 1,"x")

then use =concatenate(text(countif(range for column 1,"x"),0),"/",31,"
","days") to acheive the resulting requirement.
 
Seeing Naraines solution, here's an easier combination of our
two solutions

=COUNTIF(A2:A32,"x")&"/31 days"

Dan E
 
Josh

=COUNTIF(A1:AE1,"=x")&"/31 Days"

Assuming 31(not 32) days in December.

Gord Dibben Excel MVP
 
Back
Top