Forum Discussion

Gemma Telfer's avatar
Gemma Telfer
Copper Contributor
Nov 14, 2019

SumIf multiple columns

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. ...
excel
Formulas and Functions
sumif
Gemma Telfer's avatar
Gemma Telfer
Copper Contributor
Nov 14, 2019

Hi SergeiBaklan 

 

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's avatar
    Gemma Telfer
    Copper Contributor
    Nov 14, 2019

    Gemma Telfer 

     

    maybe got around it although not in a sleek way.

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

Resources