KayJay0618
New Member
- Joined
- Jul 20, 2016
- Messages
- 40
I have an Excel 2010 worksheet tracking homeless client data for a cold weather shelter for families. Each family is assigned a number. If there are 5 members in the family, they will all have the same unique family number. The Family # is in column D of the spreadsheet. One of the family members is designated as Household Head with a Y in column G. Only one family member will have a Y in this column. If any of the family members have an income of any kind, that annual income amount is entered in column W. In column X on the row with a Y in column H, I need a formula that will sum the income for that unique family. Sample data below. The last column is what the total should be.
<tbody>
</tbody>
Month of Service | Date Entered Shelter | Date Exited Shelter | Family # | First Name | Last Name | Head of House | Single Parent | Sex | Age | Household Number | -18 | +18 | Disabled | Veteran | Case Status | Ongoing Status | Main Source of Income | Source of Income-2 | Source of Income-3 | Source of Income-4 | Monthly Income | Yearly Income | Total Family Income |
Jul | 7/1/2017 | 1 | Jane | Doe | Y | Y | F | 32 | 2 | 1 | 1 | N | WC | $ 22,000.00 | 30,772.00 | ||||||||
Jul | 7/2/2017 | 1 | Cindy | Doe | F | 17 | 5 | 2 | 3 | Y | SSD | $ 8,772.00 | |||||||||||
Jul | 7/3/2017 | 2 | Joe | Smith | Y | M | 28 | 4 | 2 | 2 | N | FT | CS | $ 37,380.72 | 52,380.72 | ||||||||
Jul | 7/4/2017 | 2 | Jane | Smith | F | 7 | 3 | 2 | 1 | N | FT | $ - | |||||||||||
Jul | 7/5/2017 | 2 | **** | Smith | M | 9 | 4 | 2 | 2 | N | FT | $ - | |||||||||||
Jul | 7/6/2017 | 2 | Tom | Smith | M | 15 | 1 | 0 | 1 | N | SS | $5,000.00 | |||||||||||
Jul | 7/7/2017 | 2 | Billy | Smith | M | 17 | 4 | 3 | 1 | N | CS | $ 10,000.00 |
<tbody>
</tbody>