SUMIF w/multiple conditions

  • Thread starter Thread starter JANA
  • Start date Start date
J

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
 
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
 
Back
Top