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

Tammy Duggan's avatar
Tammy Duggan
Copper Contributor
Mar 05, 2018

I am trying to do the same thing across a workbook for each month of the year. My formula is =SUMIF('M-4:SU-4'!C15,"CIP",'M-4:SU-4'!F15)

Each row is for an employee (15 is just one) M=Monday and SU=Sunday. CIP is job description (Construction in Progress), Column "F" is total hours for that day.
I am trying to pull the total hours of CIP for each week for each employee and when I put the above formula in I get a #Value! error. I double checked all cells for errors and everything looks fine. I don't know what I am missing. Thank you. Tammy

H S Desai's avatar
H S Desai
Copper Contributor
Mar 06, 2018

Maybe because you dont have the range of cells to add?