Forum Discussion

Steven Elphick's avatar
Steven Elphick
Copper Contributor
Feb 06, 2018
Solved

Excel formula help

Hi there,   I am looking to find the easiest formula solution for the following.   I wish to check if table a5:a32 contains the word "MTD", if so, it takes data from a cell in the same row fr...
Formulas & Functions
Requests
  • Damien_Rosario's avatar
    Damien_Rosario
    Feb 06, 2018

    Hi Steven

     

    If I am understanding you right, try this formula:

     

    =SUMIF(A2:A5,"MTD",B2:B5)

     

    Change A to your desired column where the MTD text is located.

    Change B to where the $ column is located.

     

    Basically, this formula will do what you have asked.

     

    I have also attached a sample file to demo the above for you to see it in action.

     

    Let us know how you go?

     

    Cheers

    Damien