Forum Discussion
Excel formula help
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
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
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. TammyMaybe because you dont have the range of cells to add?
I am not sure why you cant get it?
Is this what you are trying to do?
SUMIF(C5:C9,"CIP",D5:D9)
it is basically what I am trying to do. I have uploaded the workbook. I need to figure out how to get the total CIP per employee per week.
- Hi Tammy
Could I suggest that you make a new post on this so we can look at it?
If possible, could you also upload a sample of the file for review?
Cheers
DamienShould I still make a new post? I uploaded my workbook.
Hi Damien
I was looking for an answer which is exactly opp of this solution.Meaning I want to exclude any rows that contain the word "MTD" and not include in the sum total. How do I write that formula?
sumif(A1:A5, NOT "MTD", B1:B5)
Logic is as above but am not sure what syntax to use
- Hi H S Desai
Try:
=SUMIF(A2:A5, "<>MTD",B2:B5)
<> means does not equal. Make sure it's in the " " as well.
Let me know how you go?
Cheers
Damiengot it works perfectly. Also tried the sumifs function to add more conditions to exclude. Thank you
Thanks Damien,
Works exactly as requested. Thank you
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
