Ok I'm trying to make a formula that says if cells C5-56 (C5:C56)
have an "X" in them, then count the number of x's in cell G5:G56.
I want the total number of x's in the range G5 through G56 IF the
corrosponding
cells in C5:C56 have an X.

This is a list of beds (in a hospital) that are a certain type of bed and if
they are salvageable. (they're broken)
So C5-56 are marked with an x IF the bed is a Total Care bed.
E5-E56 are marked with an x IF the bed is a Zone Air bed.
G5-G56 are marked with an X IF the bed is salvageable.
I need the number of salvageable beds for the Total Cares and for the
Zoneairs and for those that are neither(these would nOT have an x in either
c5-56 NOR G5-56) So I need three different formulas.
Yikes... I hope this makes sense