sum totals in one column if values in another column are equal

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.[TABLE="width: 1266"]
<tbody>[TR]
[TD]Month of Service[/TD]
[TD]Date Entered Shelter[/TD]
[TD]Date Exited Shelter[/TD]
[TD]Family #[/TD]
[TD]First Name [/TD]
[TD]Last Name[/TD]
[TD]Head of House[/TD]
[TD]Single Parent[/TD]
[TD]Sex[/TD]
[TD]Age[/TD]
[TD]Household Number[/TD]
[TD]-18[/TD]
[TD]+18[/TD]
[TD]Disabled[/TD]
[TD]Veteran[/TD]
[TD]Case Status[/TD]
[TD]Ongoing Status[/TD]
[TD]Main Source of Income[/TD]
[TD]Source of Income-2[/TD]
[TD]Source of Income-3[/TD]
[TD]Source of Income-4[/TD]
[TD]Monthly Income[/TD]
[TD]Yearly Income[/TD]
[TD]Total Family Income[/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD]7/1/2017[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]Jane[/TD]
[TD]Doe[/TD]
[TD]Y[/TD]
[TD]Y[/TD]
[TD]F[/TD]
[TD]32[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]N[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]WC[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $ 22,000.00 [/TD]
[TD]30,772.00[/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD]7/2/2017[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]Cindy[/TD]
[TD]Doe[/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]17[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]Y[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]SSD[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $ 8,772.00 [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD]7/3/2017[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Joe[/TD]
[TD]Smith[/TD]
[TD]Y[/TD]
[TD][/TD]
[TD]M[/TD]
[TD]28[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]N[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]FT[/TD]
[TD]CS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $ 37,380.72 [/TD]
[TD]52,380.72[/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD]7/4/2017[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Jane[/TD]
[TD]Smith[/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]7[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]N[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]FT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $ - [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD]7/5/2017[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]****[/TD]
[TD]Smith[/TD]
[TD][/TD]
[TD][/TD]
[TD]M[/TD]
[TD]9[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]N[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]FT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $ - [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD]7/6/2017[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Tom[/TD]
[TD]Smith[/TD]
[TD][/TD]
[TD][/TD]
[TD]M[/TD]
[TD]15[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]N[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]SS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]$5,000.00 [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD]7/7/2017[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Billy[/TD]
[TD]Smith[/TD]
[TD][/TD]
[TD][/TD]
[TD]M[/TD]
[TD]17[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]N[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]CS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $ 10,000.00 [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
It worked. I've danced around formulas for hours. Almost had this but "missed it by that much" so thank you so much!:rolleyes:
 
Upvote 0

Forum statistics

Threads
1,226,693
Messages
6,192,468
Members
453,726
Latest member
JoeH57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top