If cell contains text "Labour" then return value from another cell.

[Channels]

Good Day; This is my first post, so please forgive me if I don't quite get my point across right.
I'm trying to set up a simple formula with column "J"; that whenever I enter labour in column "C"; it gives me a total in column "J". I have tried {=IF(C6="Labour",G6+H6,) } or {=IF(C6="Labour",I6,,) with no luck.
I would like the labour cell to show either the sub total or add G6 and H6. But I just can't make it work.
Any Useful suggestions?
Thanks for taking the time consider this.



----------A-----------B---------------- C-----------------D-----------------------E---------------------F----------G--------------H------------I-----------J-------------K------------------L

1]-----Date-------Source---------Description--------Unit Price----------------QTY---------------Taxed------Net Price-------Tax-------Sub-Total--Labour------10% markup-------Total
2]
3] 26-Jul-18----Hardware--------Holder-------------$15.00-------------------1------------------------------$15.00---------$----------$15.00----$--------------$1.50------------$16.50
4] 26-Jul-18----Services---------1 Litre Oil----------$10.00-------------------1--------------------x---------$10.00---------$1.30-----$11.30----$--------------$4.18------------$45.99
5] 26-Jul-18----Compressor-----Misc. Brass--------$22.94--------------------1--------------------x---------$22.94---------$2.98-----$25.92----$--------------$2.59------------$28.51
6] 28-Jul-18-----Labour----------Labour-------------$25.75-------------------4.75-----------------x---------$122.31--------$3.35-----$125.66--$125.66------$0.00------------$125.66

[scottiex]

this should work.

Please Login or Register  to view this content.

maybe you have spaces in it in which case

Please Login or Register  to view this content.

what does it give you as a result? just blank?

[Channels]

Good day and Thank you scottiex for your reply. The formula works; I have been trying to solve this for over three weeks now. I know I could add a couple of columns to do the something; it just bugged me that I couldn't figure out something. Thank you for taking the time to look at this, I would never would have thought of the "trim" function. It was never suggested on any of the Excel tutorials sites.

[scottiex]

You are welcome,
Great to hear my guess was correct.


mark the thread as solved and click an add reputation star if appropriate