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