Formula Help

[How_Do_I]

Here is a sample of my data, "Monday" will appear more than once in Column B but there will only be one Monday with "3" in Column A... How would I return the "01:05:03" to G2 please?

Excel Workbook
	A	B	C	D	E	F	G
1	Helper	Day	Duraton		Helper	Day	Duration
2	9	Saturday	00:57:47		3	Monday
3	8	Sunday	00:58:42
4	3	Monday	01:05:03
5	9	Tuesday	00:56:28
Sheet1

 

[pvr928]

Hi How_Do_I

Does this do what you want (in Cell G2)?

=SUMPRODUCT(--($A$2:$A$5=$E$2),--($B$2:$B$5=$F$2),$C$2:$C$5)

Cheers

pvr928

 

[How_Do_I]

It certainly does thank you pvr928...! Thanks again.

 

[jtakw]

Hi,

A simple SUMIFS will work also:

Book1
	A	B	C	D	E	F	G
1	Helper	Day	Duraton		Helper	Day	Duration
2	9	Saturday	0:57:47		3	Monday	1:05:03
3	8	Sunday	0:58:42
4	3	Monday	1:05:03
5	9	Tuesday	0:56:28
Sheet17

Cell Formulas
Range	Formula
G2	=SUMIFS(C2:C5,A2:A5,E2,B2:B5,F2)

 

[How_Do_I]

Thanks jtakw

 

[How_Do_I]

My next question is, how would I find the row that "Monday" in Column B and "3" in column A appear in please?

 

[jtakw]

Thanks jtakw

You're welcome.

Do you mean Conditional Formatting to have the resultant Cell/Row highlighted?

 

[How_Do_I]

No jtakw, the actual row which I think I've got. I changed the OP to add Named Ranges:

=SUMPRODUCT(--(Helper=E2),--(Day=F2),ROW(Duraton))

 

[pvr928]

Try (entered as an array formula (SHIFT + CTRL + ENTER)) in cell I2:

=SMALL(IF(($E$2=$A$2:$A$5)*($F$2=$B$2:$B$5),ROW($A$2:$A$5),""),1)

Cheers

pvr928

 

[How_Do_I]

Cheers pvr928