# sumifs with extra columns

1. ## sumifs with extra columns

Hi guys,

I am trying to sum a few columns together with a criteria. Can someone please offer guidance on the formula I should use please?

my sheet attachd.

I want a formula in cell IC26 please to add cells from the holiday payment column (column IC) if the column HR to pay? (column IG) has yes inserted. Another caveat.. for test 11 (row 13), I need to add use IJ13 instead of IC13... so values in column IJ should prioritise column IC.

thanks!

MAy be:

3. ## Re: sumifs with extra columns

you certainly don't need the array formula you have in IC27, this simple sumif formula will give you the same result... =SUMIF(IG3:IG18,"yes",IC3:IC18)

What I'm not quite understanding is, are you saying if a value exists anywhere in column IJ it should override the value in IC?
if so, perhaps you could add that condition to your index formula in column IC from IC3 to IC18?
like this...
=IF(IJ13<>"",IJ13,INDEX(March 2021'!\$L\$2:\$L\$29,MATCH('HR '!\$A13,March 2021'!\$A\$2:\$A\$25,0)))
I had to remove the additional paths since I cannot access them, but maybe that will be an option for you.

4. ## Re: sumifs with extra columns

Maybe try

=SUMIFS(IC3:IC20,IC3:IC20, "<>#N/A",\$IG\$3:\$IG\$20,"yes",IJ3:IJ20,"=")+SUMIFS(IJ3:IJ20,IG3:IG20,"Yes")

5. ## Re: sumifs with extra columns

THANK YOU ALL! Rep added. The solutions you gave work :-)

There are currently 1 users browsing this thread. (0 members and 1 guests)