SUMIF w/multiple conditions

[JANA]

Is it possible to do a SUMIF with 2 conditions? See below
Want a formula so that if the name & number in
Spreadsheet A both match the name & number in spreadsheet
B, it will sum the hours in column C.

Spreadsheet A has each employee & number listed once,
while spreadsheet B has employees & numbers listed
numerous times

SPREADSHEET A

COLUMN A COLUMN B COLUMN C
1 NAME NUMBER formula???


SPREADSHEET B
COLUMN A COLUMN B COLUMN C
1 NAME NUMBER HOURS

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--('sheetb'!$A$1:$A$100=A1),--('sheetb'!$B$1:$B$100=B1),'sh
eetb'!$C$1:$C$100)
and format column c with the custom format
[hh]:mm