Index Match Functions
Hi Gene,
Am Fri, 12 Apr 2019 23:34:30 +0100 schrieb Gene Haines:
I that match JO, TSTSD and KO.
Sheet1
JO TSTSD KO Labor Dollars
60770 JIJ7 010 $15,843
Sheet2
JO TSTSD KO Labor Hrs Total
Dollars
60770 JIJ7 010 354
$15,843
try:
=SUMPRODUCT((Sheet1!A2:A64=A2)*(Sheet1!B2:B64=B2)* (Sheet1!C2:C64=C2)*Sheet1!D2:D64)
Regards
Claus B.
--
Windows10
Office 2016
|