A Lesson in Counting needed

[akaivyleaf]

I fear I need to go back to Kindergarten this evening. Hopefully I can explain my scenario enough to get a workable answer.

I have 4 columns of data with X's in the correct row. Column B asks if the person has dementia, column C asks if the person is a caregiver to the person with Dementia, Column D asks if the person is under 60 years of age, Column E asks if the person is 60+.

The problem: I need to count two things:
1. those persons Under 60 with dementia
2. Those persons 60+ who are caregivers

<table border="0" cellpadding="0" cellspacing="0" width="376"><col style="mso-width-source:userset;mso-width-alt:3401; width:70pt" span="2" width="93"> <col style="mso-width-source:userset;mso-width-alt:3474; width:71pt" span="2" width="95"> <tbody><tr style="mso-height-source:userset;height:29.25pt" height="39"> <td class="xl67" style="height:29.25pt;width:70pt" height="39" width="93">Person with</td> <td class="xl72" style="width:70pt" width="93">Caregiver</td> <td class="xl73" style="width:71pt" width="95"></td> <td class="xl69" style="width:71pt" width="95"> </td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl68" style="height:15.75pt;border-top:none" height="21">Dementia</td> <td class="xl66" style="border-top:none"> </td> <td class="xl70" style="border-top:none;border-left:none">Under 60</td> <td class="xl71" style="border-top:none">60+</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl82" style="height:15.0pt" height="20"> </td> <td class="xl83">x</td> <td class="xl82" style="border-left:none">x</td> <td class="xl84"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl74" style="height:15.0pt;border-top:none" height="20">x</td> <td class="xl75" style="border-top:none"> </td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl86" style="height:15.0pt;border-top:none" height="20"> </td> <td class="xl87" style="border-top:none">x</td> <td class="xl86" style="border-top:none;border-left:none">x</td> <td class="xl88" style="border-top:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl74" style="height:15.0pt;border-top:none" height="20">x</td> <td class="xl75" style="border-top:none"> </td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl82" style="height:15.0pt" height="20"> </td> <td class="xl83">x</td> <td class="xl82" style="border-left:none"> </td> <td class="xl84">x</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl74" style="height:15.0pt;border-top:none" height="20">x</td> <td class="xl75" style="border-top:none"> </td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl86" style="height:15.0pt;border-top:none" height="20"> </td> <td class="xl87" style="border-top:none">x</td> <td class="xl86" style="border-top:none;border-left:none"> </td> <td class="xl88" style="border-top:none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl74" style="height:15.0pt;border-top:none" height="20">x</td> <td class="xl75" style="border-top:none"> </td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl86" style="height:15.0pt;border-top:none" height="20"> </td> <td class="xl87" style="border-top:none">x</td> <td class="xl86" style="border-top:none;border-left:none"> </td> <td class="xl88" style="border-top:none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl74" style="height:15.0pt;border-top:none" height="20">x</td> <td class="xl75" style="border-top:none"> </td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl86" style="height:15.0pt;border-top:none" height="20"> </td> <td class="xl87" style="border-top:none">x</td> <td class="xl86" style="border-top:none;border-left:none"> </td> <td class="xl88" style="border-top:none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl74" style="height:15.0pt;border-top:none" height="20">x</td> <td class="xl75" style="border-top:none"> </td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl86" style="height:15.0pt;border-top:none" height="20"> </td> <td class="xl87" style="border-top:none">x</td> <td class="xl86" style="border-top:none;border-left:none">x</td> <td class="xl88" style="border-top:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl78" style="height:15.0pt" height="20">X</td> <td class="xl79"> </td> <td class="xl89" style="border-top:none;border-left:none"> </td> <td class="xl81">X</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl74" style="height:15.0pt;border-top:none" height="20">x</td> <td class="xl75" style="border-top:none"> </td> <td class="xl80"> </td> <td class="xl76" style="border-top:none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl86" style="height:15.0pt;border-top:none" height="20"> </td> <td class="xl87" style="border-top:none">x</td> <td class="xl86" style="border-top:none;border-left:none"> </td> <td class="xl88" style="border-top:none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl86" style="height:15.0pt;border-top:none" height="20"> </td> <td class="xl87" style="border-top:none">X</td> <td class="xl86" style="border-top:none;border-left:none">X</td> <td class="xl88" style="border-top:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl74" style="height:15.0pt;border-top:none" height="20">X</td> <td class="xl75" style="border-top:none"> </td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none">X</td> </tr> </tbody></table>

Maybe its late, but I'm just dead in the water here about a formula. Any help would be much appreciated.

(I realize I might not have conducted a thorough search, but I will be a willing contributor to this message board in the future)

 

[T. Valko]

I fear I need to go back to Kindergarten this evening. Hopefully I can explain my scenario enough to get a workable answer.

I have 4 columns of data with X's in the correct row. Column B asks if the person has dementia, column C asks if the person is a caregiver to the person with Dementia, Column D asks if the person is under 60 years of age, Column E asks if the person is 60+.

The problem: I need to count two things:
1. those persons Under 60 with dementia
2. Those persons 60+ who are caregivers

<TABLE cellSpacing=0 cellPadding=0 width=376 border=0><COLGROUP><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" span=2 width=93><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" span=2 width=95><TBODY><TR style="HEIGHT: 29.25pt; mso-height-source: userset" height=39><TD class=xl67 style="WIDTH: 70pt; HEIGHT: 29.25pt" width=93 height=39>Person with</TD><TD class=xl72 style="WIDTH: 70pt" width=93>Caregiver</TD><TD class=xl73 style="WIDTH: 71pt" width=95></TD><TD class=xl69 style="WIDTH: 71pt" width=95></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl68 style="BORDER-TOP: medium none; HEIGHT: 15.75pt" height=21>Dementia</TD><TD class=xl66 style="BORDER-TOP: medium none"></TD><TD class=xl70 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">Under 60</TD><TD class=xl71 style="BORDER-TOP: medium none">60+</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl82 style="HEIGHT: 15pt" height=20></TD><TD class=xl83>x</TD><TD class=xl82 style="BORDER-LEFT: medium none">x</TD><TD class=xl84></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20>x</TD><TD class=xl75 style="BORDER-TOP: medium none"></TD><TD class=xl74 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl76 style="BORDER-TOP: medium none">x</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl86 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20></TD><TD class=xl87 style="BORDER-TOP: medium none">x</TD><TD class=xl86 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">x</TD><TD class=xl88 style="BORDER-TOP: medium none"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20>x</TD><TD class=xl75 style="BORDER-TOP: medium none"></TD><TD class=xl74 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl76 style="BORDER-TOP: medium none">x</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl82 style="HEIGHT: 15pt" height=20></TD><TD class=xl83>x</TD><TD class=xl82 style="BORDER-LEFT: medium none"></TD><TD class=xl84>x</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20>x</TD><TD class=xl75 style="BORDER-TOP: medium none"></TD><TD class=xl74 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl76 style="BORDER-TOP: medium none">x</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl86 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20></TD><TD class=xl87 style="BORDER-TOP: medium none">x</TD><TD class=xl86 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl88 style="BORDER-TOP: medium none">x</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20>x</TD><TD class=xl75 style="BORDER-TOP: medium none"></TD><TD class=xl74 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl76 style="BORDER-TOP: medium none">x</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl86 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20></TD><TD class=xl87 style="BORDER-TOP: medium none">x</TD><TD class=xl86 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl88 style="BORDER-TOP: medium none">x</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20>x</TD><TD class=xl75 style="BORDER-TOP: medium none"></TD><TD class=xl74 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl76 style="BORDER-TOP: medium none">x</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl86 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20></TD><TD class=xl87 style="BORDER-TOP: medium none">x</TD><TD class=xl86 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl88 style="BORDER-TOP: medium none">x</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20>x</TD><TD class=xl75 style="BORDER-TOP: medium none"></TD><TD class=xl74 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl76 style="BORDER-TOP: medium none">x</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl86 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20></TD><TD class=xl87 style="BORDER-TOP: medium none">x</TD><TD class=xl86 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">x</TD><TD class=xl88 style="BORDER-TOP: medium none"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl78 style="HEIGHT: 15pt" height=20>X</TD><TD class=xl79></TD><TD class=xl89 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl81>X</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20>x</TD><TD class=xl75 style="BORDER-TOP: medium none"></TD><TD class=xl80></TD><TD class=xl76 style="BORDER-TOP: medium none">x</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl86 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20></TD><TD class=xl87 style="BORDER-TOP: medium none">x</TD><TD class=xl86 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl88 style="BORDER-TOP: medium none">x</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl86 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20></TD><TD class=xl87 style="BORDER-TOP: medium none">X</TD><TD class=xl86 style="BORDER-TOP: medium none; BORDER-LEFT: medium none">X</TD><TD class=xl88 style="BORDER-TOP: medium none"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-TOP: medium none; HEIGHT: 15pt" height=20>X</TD><TD class=xl75 style="BORDER-TOP: medium none"></TD><TD class=xl74 style="BORDER-TOP: medium none; BORDER-LEFT: medium none"></TD><TD class=xl76 style="BORDER-TOP: medium none">X</TD></TR></TBODY></TABLE>

Maybe its late, but I'm just dead in the water here about a formula. Any help would be much appreciated.

(I realize I might not have conducted a thorough search, but I will be a willing contributor to this message board in the future)

What version of Excel are you using?

 

[akaivyleaf]

Excel 2007

 

[T. Valko]

Excel 2007

Try these:

1. those persons Under 60 with dementia

=COUNTIFS(A2:A19,"x",C2:C19,"x")

2. those persons 60+ who are caregivers

=COUNTIFS(B2:B19,"x",D2:D19,"x")

 

[akaivyleaf]

Thank you SOOOO Much. I truly APPRECIATE it.

 

[T. Valko]

Thank you SOOOO Much. I truly APPRECIATE it.

You're welcome. Thanks for the feedback!