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 parti...
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
I'm sorry, I don't understand. Can you provide an example to explain what you mean? Thanks in advance.
so different question, i need to get total hours of billable column e, if "AI", "W" and "CDAM" then add hours in column C it's not working my formulaHansVogelaar
