CODEWITHSUNDEEP
google-sheets
Roy Berris
Roy Berris

Reputation: 1572

SUM time values where column to the right has specific string value

In my specific example I have a time sheet, and for each project I will just add a tag next to the time spend. Like "Project1" or "Project2". What I want to archieve is to show a SUM of the time spend on this project and show it on a sheet with project name and total time spend. Is this possible?

See attached image for example.

Example picture

I want the calculation to show in cells G2 and G3

Upvotes: 0

Views: 19

Answers (2)

pnuts
pnuts

Reputation: 59450

Please try in G2 and copied down to suit (with formatting as Duration):

=sumif(C:C,F2,B:B)

Upvotes: 0

JPV
JPV

Reputation: 27252

See if this works (for the example you showed us above)

=ArrayFormula(query({value(B3:B), C3:C}, "select Col2, sum(Col1) where Col2 <>'' group by Col2 label sum(Col1) '' format sum(Col1) 'hh:mm'"))

Note: format the second column of the output as duration (via the 123-menu).

Example

Upvotes: 1

Related Questions