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

Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
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

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

Thanks Damien,

 

Works exactly as requested. Thank you

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Feb 06, 2018

    Glad I could help, Steven.

    Could you flag the answer as the best response so that other forum users will know what the solution is for their reference?

    All the best
    Damien