Need help with SumIF Array for single criteria multiple columns

[gsimons85]

Hi

Trying to add multiple columns based on a single criteria using SUMIF, but can't seem to figure it out. I want to add anything in columns E2:K26 based off D2:D26 that is categorized as "Income"


[TABLE="width: 1557"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Description/Comments[/TD]
[TD]Income/Expense[/TD]
[TD]Dues[/TD]
[TD]Military Chaplin Fund[/TD]
[TD]50/50[/TD]
[TD]Chalice Fund[/TD]
[TD]St.Katherine Drexel School[/TD]
[TD]Miscellaneous[/TD]
[TD]Other[/TD]
[/TR]
[TR]
[TD]8/26/2015[/TD]
[TD]Mark Dues[/TD]
[TD]Income[/TD]
[TD]$200.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8/27/2015[/TD]
[TD]Paid for table at conference[/TD]
[TD]Expense[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]($300.00)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8/28/2015[/TD]
[TD]deposit from bake sale[/TD]
[TD]Income[/TD]
[TD][/TD]
[TD]$108.34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9/10/2015[/TD]
[TD]September Dues[/TD]
[TD]Income[/TD]
[TD]$475.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thanks in advance
Greg

 

[Weazel]

maybe something like....

=SUMPRODUCT((C2:C5="income")*(D2:J5))

 

[gsimons85]

Thats perfect.! Thanks for your help