Need an if excel formula

[johnwells13]

A bunch of people are staying in an airbnb with me. They are all staying different nights though. I am creating a excell sheet and having them put an x for every night they are staying. I am wanting a formula that adds the total times an "x" appears in each column, and then have total rate per night divided by that value. Help please!

 

[Michael M]

You haven't provided any specifics, but have a look at the total rate per night divided by a countif.
So, assuming the the "x"s are in col "B" from rows 1 to 10 AND the total is in C10, you would use

=C10/COUNTIF(B1:B10,"x")

 

[johnwells13]

You haven't provided any specifics, but have a look at the total rate per night divided by a countif.
So, assuming the the "x"s are in col "B" from rows 1 to 10 AND the total is in C10, you would use

=C10/COUNTIF(B1:B10,"x")

Perfect, Thank you!

 

[Michael M]

Glad to help...