Excel 2010: Add hours in certain cells?

[MsCynic]

Hi guys,

I have a timesheet that includes occasions on which I worked for multiple clients. These rows have the words "joint work" in column G. I need to separate these out in my invoice to be billed separately.

Column F contains the amount of time worked in digital format. Column G contains the instances of "joint work".

What formula would I need to sum column f when column g contains "joint work"?

thanks in advance for advice,
Jo

 

[Aladin Akyurek]

Hi guys,

I have a timesheet that includes occasions on which I worked for multiple clients. These rows have the words "joint work" in column G. I need to separate these out in my invoice to be billed separately.

Column F contains the amount of time worked in digital format. Column G contains the instances of "joint work".

What formula would I need to sum column f when column g contains "joint work"?

thanks in advance for advice,
Jo

Something like...

=SUMIF($G$2:$G$100,"joint work",$F$2:$F$100)

 

[MsCynic]

Perfect! Thanks so much for your fast and helpful reply.

 

[Aladin Akyurek]

Perfect! Thanks so much for your fast and helpful reply.

You are welcome. Thanks for providing feedback.