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 ...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 15, 2019

senelson227 

I'd suggest to use SUMPRODUCT in such case

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

 

Resources