Forum Discussion
Formula Help
Hi, i need help with a formula. I have a file that in one column has codes the other column has total of time (basically it's a time sheet for an employee and they code what they did in that particular time) So i want to return if equals T for travel then add up all the hours in that day they traveled. Is this possible?
26 Replies
- I have 2 codes now "TN" and "TB" if I add them it doesn't work
For example in H29:
=SUMIF(E6:E27,"T ",C6:C27)
Note that I used "T ". This is because the code in Y12 contains a space after T. If you remove this, use
=SUMIF(E6:E27,"T",C6:C27)
Thank you. ! more questions seems my hours are rounding up can you check my ttotals how do i fix thatHansVogelaar
- HansVogelaar I have 2 codes now "TN" and "TB" if I add them it doesn't work I NEED TO COUNT HOW MANY OF MORE THAN ONE CODE IN A SPECIFIC CELL
