I am trying to sum cells with specific text and cell colour, I know how to use the colour function to sum cells by colour but how do I combine the both to get the desired result.
I have included a workbook showing what I am trying to achieve, I want to sum the cells that are green and say MED, which total 14:00hrs
Thanks for any help or advice.
Bookmarks