summing multiple columns with SUMIF

[senelson227]

I want to sum multiple columns based on the criteria in a column. Here is the formula I am using:

sumif('2019 Budget'!$D$14:$D$109,"esop",'2019 Budget'!G14:I109)

January's budget numbers are in column G and February's budget numbers are in column I

In my mind this formula should work but it is only summing column G.

Any help would be greatly appreciated.

[#2]

@senelson227 

I'd suggest to use SUMPRODUCT in such case

=SUMPRODUCT(('2019 Budget'!$D$14:$D$109="esop")*'2019 Budget'!G14:I109)