CODEWITHSUNDEEP
google-sheets-formulaformula
SleepWalker
SleepWalker

Reputation: 637

multiple condition inside SUMIF() in google sheets

I created my daily task log sheet which i log my tasks daily and I also provide the time which I start and the time of its completion. it looks like this

enter image description here

You'll notice the tab "total hours per day". on that tab I calculate the total time for the specific date. It looks like this

enter image description here

using this formula: =SUMIF('TASKS (Itemized)'!A3:A501,A8,'TASKS (Itemized)'!I3:I501)

My question is can I still add a condition to the formula that says not to include the time or the row if the column H has a value of "Multitasking"?

Upvotes: 0

Views: 188

Answers (1)

Kevin P.
Kevin P.

Reputation: 1053

I believe you are looking for something like this?

=SUMIFS('TASKS (Itemized)'!I3:I,'TASKS (Itemized)'!A3:A,A8,'TASKS (Itemized)'!H3:H,"<>Multitasking")

Without seeing a sample sheet of everything going on including columns and rows this is the best I can offer.

Upvotes: 1

Related Questions