2 arguments help

[CVN55]

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 words, but I can't work out how to condition it further to just be picking up those medical values which are linked to research values:

=IF(K8:K13="research",SUMIF(G8:G13,"Medical",M8:M13),0)

Thank you for any help,
Catherine

 

[Jonmo1]

Try sumifS

=SUMIFS(M8:M13,G8:G13,"Medical",K8:K13,"research")

 

[CVN55]

Thank you so much for this, worked perfectly!
I have another query along the same lines....
Same arguments, so if column K has research and column G has medical, then I want column J multiplied by column M - sumproduct I'm guessing?
Thanks again for your help,
Catherine

 

[CVN55]

This is what should work in my head, but doesn't!
=SUMIFS(SUMPRODUCT(M8:M14,J8:J14/60),$G$8:$G$14,"Medical",$K$8:$K$14,"Research")
Dividing by 60 as column J is in minutes...

 

[FormR]

This is what should work in my head, but doesn't!
=SUMIFS(SUMPRODUCT(M8:M14,J8:J14/60),$G$8:$G$14,"Medical",$K$8:$K$14,"Research")

Hi, you could try like this instead:

=SUMPRODUCT(M8:M14,J8:J14/60,--($G$8:$G$14="Medical"),--($K$8:$K$14="Research"))

 

[CVN55]

Hi, you could try like this instead:

=SUMPRODUCT(M8:M14,J8:J14/60,--($G$8:$G$14="Medical"),--($K$8:$K$14="Research"))

Thank you, this has done the trick, genius!

 

[Jonmo1]

Why the /60 ??

This should work.
=SUMPRODUCT(--($G$8:$G$13="Medical"),--($K$8:$K$13="Research"),$M$8:$M$13*$J$8:$J$13)