Sum Multiple Lines based on Multiple Criteria

**Netsirkf** · 10-29-2018, 05:26 AM

Hi,

I'm sure the solution to this is pretty simple, but I can't work out whether the issue is because the sum is time or the formula's I am trying. I want the table to the right to sum the times that fit the criteria on both axis, so for example all the times for "Andrew W" in the state "Alerting" to sum and show in the table to the right (sorry but it won't let me attach a file for some reason).

Thanks

Capture.JPG

**Sam Capricci** · 10-29-2018, 05:33 AM

I'm guessing since there is no sample but maybe =SUMPRODUCT(($A:$A=$E2)*($B:$B=F$1)*($C:$C)) dragged down and right.

AND, by the way, I'd adjust the ranges instead of using whole columns.

**Bo_Ry** · 10-29-2018, 05:34 AM

Please try

F2 copy to H3
=SUMIFS($C1:$C99,$A1:$A99,$E2,$B$1:$B$99,F$1)

Select F2:H3 and set Custom Format to [hh]:mm:ss

**Netsirkf** · 10-29-2018, 05:41 AM

Originally Posted by Sambo kid

I'm guessing since there is no sample but maybe =SUMPRODUCT((A:A=$E2)*(B:B=F$1)*(C:C)) dragged down and right.

Thanks for this, I thought it should be something like that too, but I just get #VALUE! error's.

**Netsirkf** · 10-29-2018, 05:45 AM

Originally Posted by Bo_Ry

Please try

F2 copy to H3
=SUMIFS($C1:$C99,$A1:$A99,$E2,$B$1:$B$99,F$1)

Select F2:H3 and set Custom Format to [hh]:mm:ss

That worked! Many Thanks

**Sam Capricci** · 10-29-2018, 05:49 AM

I forgot to add absolutes to mine so it likely would error out after the first column (see it now). But without a sample to test against I was only guessing. A sumifs is probably as good as option as any and so glad you got your answer from Bo_Ry.

Sum Multiple Lines based on Multiple Criteria

LinkBack

Thread Tools

Rate This Thread

Display

Sum Multiple Lines based on Multiple Criteria

Re: Sum Multiple Lines based on Multiple Criteria

Re: Sum Multiple Lines based on Multiple Criteria

Re: Sum Multiple Lines based on Multiple Criteria

Re: Sum Multiple Lines based on Multiple Criteria

Re: Sum Multiple Lines based on Multiple Criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Merge multiple sheets data into 1 sheet based on multiple criteria (List Based)

[SOLVED] Grab lines of data from sheet based on multiple criteria (working slightly)

Count/Find X on multiple lines w/ multiple criteria

Match lines with Multiple Specific Criteria

Select a cell at random based on multiple selection criteria across multiple sheets.

[SOLVED] Find matching lines based on multiple criteria

Create multiple lines based upon criteria

Bookmarks

Bookmarks

Posting Permissions