Count Formula

[superkopite]

Hi Guys,

I have a problem, I am terrible at count formula!!!

I have in Column E2:E30 a time in minutes
I have in Column F2:F30 a job role eg RDM, BPL, Store Manager

In Cell E61 I need to add all the mins together that RDM has allocated to him

Does that make sense??

 

[grizz]

try this

=SUMIF($F$2:$F$30,"RDM",$E$2:$E$30)

 

[superkopite]

That is an amazing formula i never knew you could extrapalate like that

thanks!!!

 

[superkopite]

I have now need to refine my code a little


and what I am trying isn't working

Basically I want to look up another column and see if RDM is there and add the value twice if he appears in both colulmns.

this is what I tried

=SUMIF($F$2:$F$50,"RDM",$E$2:$E$50)+SUMIF($H$2:$H$50,"RDM",$H$2:$H$50)

But it doesn't work

any ideas guys and gals???