Forum Discussion
senelson227
Aug 15, 2019Copper Contributor
summing multiple columns with SUMIF
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.
1 Reply
Sort By
- SergeiBaklanDiamond Contributor
I'd suggest to use SUMPRODUCT in such case
=SUMPRODUCT(('2019 Budget'!$D$14:$D$109="esop")*'2019 Budget'!G14:I109)