SumIf multiple columns

[Gemma Telfer]

Hi 

I am trying to sumif when the criteria and range are in multiple columns. Is this possible please?

So I need to know if Anytown's money has been awarded to a project in another location. 

[#2]

@Gemma Telfer 

Perhaps

=SUMIFS(I:I,D:D,"Anytown",G:G,"Anytown")

[#3]

Hi @Sergei Baklan 

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.

[#4]

@Gemma Telfer 

maybe got around it although not in a sleek way.

=(SUMIF(D:D,"Anytown",F:F))+(SUMIF(G:G,"anytown",I:I))