Hi
I have column K which if the word 'research' is in there, then I want column G to then be looked at and if the word 'medical' is in there, then I want the sum of those research/medical figures in column M to be added.
The red bit below works on it's own just for adding up all the medical...