VLookup

[mulholm]

Is there a way to do V Lookup with multiple parameters.

I will try explain as best as i can below what i'm looking for:

Paid Breaks
Name	Break Time Available	Break Time Used
Agent1
Agent2

<tbody>
</tbody>

this is what appears on sheet1

On sheet 2 i have the following data:

Agent	Category	Activity	Duration Mins	Duration (Secs)	Duration%
Agent1	ASH	Unpaid Break	420	25,200	9.38%
Agent1	OffLine	Paid Break	4	227	0.08%

<tbody>
</tbody>

On sheet1 i have used V Look up function to search for "Agent1" and return data from column "5" which is the duration of the code they used and put it in "Break Time Used" column. However i am looking to only retrieve for "Paid Break" only which is where it gets confusing.

Is there a way to use V Look up and ignore "Unpaid Break" and only return "Paid Break"

 

[RasGhul]

Try,

=SUMPRODUCT(($A$2:$A$3=A9)*($C$2:$C$3="Paid Break")*$E$2:$E$3)

 

[Aladin Akyurek]

=SUMIFS(Sheet2!E:E,Sheet2!A:A,$A3,Sheet2!C:C,"paid break")

where A3 = Agent1.

 

[mulholm]

that worked perfectly

 

[Aladin Akyurek]

that worked perfectly

Great, thanks for the update.