I have a big problem.I have data on members of 6000 households, with the
income of each and every member.now i want total income for each household.
for eg

household 1 member 1 $1000 total= 2300
member 2 $800
member 3 $500

Household 2 member 1 $200 total= 2200
member 2 $2000

household 3 member 1 $1000 total=2800
member 2 $500
member 3 $300

any help would be greatly appreciated. thx

you can sumif function for example you have household name in col A and
amount in col B then formulda wud be like this:
=SUMIF(A1:A100,"Household1",B1:B100)

"muzz46" wrote:

I have a big problem.I have data on members of 6000 households, with the
income of each and every member.now i want total income for each household.
for eg

household 1 member 1 $1000 total= 2300
member 2 $800
member 3 $500

Household 2 member 1 $200 total= 2200
member 2 $2000

household 3 member 1 $1000 total=2800
member 2 $500
member 3 $300

any help would be greatly appreciated. thx