sum number of x's????

[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

 

[Dan E]

Josh,

=SUM(IF(A2:A32="x",1,0))&"/31 days"
array entered (control + shift + enter)

Dan E

 

[Naraine]

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.

 

[Dan E]

Seeing Naraines solution, here's an easier combination of our
two solutions

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

Dan E

 

[Gord Dibben]

Josh

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

Assuming 31(not 32) days in December.

Gord Dibben Excel MVP

 

[Gord Dibben]

oops. Don't need the =sign

Gord

Josh

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

Assuming 31(not 32) days in December.

Gord Dibben Excel MVP