SumIf multiple columns

Question

Hi&nbsp;&nbsp;I am trying to sumif when the criteria and range are in multiple columns. Is this possible please?&nbsp;So I need to know if Anytown's money has been awarded to a project in another location.&nbsp;

sergeibaklan · Answer

Gemma Telfer&nbsp;
Perhaps
=SUMIFS(I:I,D:D,"Anytown",G:G,"Anytown")
&nbsp;

gemma telfer · Answer

Hi SergeiBaklan&nbsp;&nbsp;Thank you for that. It does seem to have worked, unfortunately. I think it is the sum range I need to work out. I need it to be able to add up column F and I based on D and G.

gemma telfer · Answer

Gemma Telfer&nbsp;&nbsp;maybe got around it although not in a sleek way.=(SUMIF(D:D,"Anytown",F:F))+(SUMIF(G:G,"anytown",I:I))

Forum Discussion

SumIf multiple columns

3 Replies

Resources