Forum Discussion

senelson227's avatar
senelson227
Copper Contributor
Aug 15, 2019

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.

Resources