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

[KayJay0618]

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.

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>

​

 

[FDibbins]

Try this...
=IF(G2="","",SUMIF(D:D,D2,W:W))
copied down

 

[KayJay0618]

It worked. I've danced around formulas for hours. Almost had this but "missed it by that much" so thank you so much!

 

[FDibbins]

happy to help