I am getting a value error, I am wanting the formula to pull up the number of equipment for the location to the left of it and based on the type of equipment above it.

Sheet view workbook Views Show zoom window Ma X =SUMPRODUCT(('Tower Crane Mast Inventory'!B4:AN31)*('Tower Crane Mast Inventory'!B1:AN1=$D$29) *('Tower Crane Mast Inventory'!A4:A31-B33)) B C E F G H K M N 0 Crane? Location Gilbert Yard - AZ # of Equipment 52 0 Equipment List For Location P800B Fishplates P850A Fishplates Anchor Stool Fishplates P802A V60 Chassis 6m cross base ZX6830 6.0m cross base ZD4230 4.5m cross base ZD2030 4.5m cross base | ZC2030 3.8m cross base 1 KRMT849C (3.3m) K850/KR800B (10m) K849/K849 (2m) KMRT849A-2 KRMT849A 40 KM850.10A (5m) KRMT839A (5m) KM850.10B (10m) KM850.10E (10m) S24E-1 S24E-2 SR24E-1 SR24E-2 - SR26E-1 SR26E-2 SR25F-1 (7m) 1 1 1 1 SR25F-Yellow K437A (5m) K437 E or B (10m) K447E (10M) K449A (5M) KRMT639A K649A Yello K649A K60/K60 K60/K40 K40/K20 Wolff TV.20 7 161-30-050 Wolff X-Base Equipment Look Up KRMT849A Number of Equipment Location of Euipment Denver Yard - CO Gilbert Yard - AZ Southwest Yard - AZ #VALUE! Colton Vard CA B Crane D E F G H Anchor Stool Fishplates P802A P800B Fishplates P850A Fishplates V60 Chassis 6m cross base ZX6830 6.0m cross base ZD4230 4.5m cross base ZD2030 4.5m cross base ZC2030 3.8m cross base KRMT849A K M N KRMT839A (5m) KRMT849C (3.3m) K850/KR800B (10m) 1 40 1 1 2 18 27 2 30 9 849a2 x2, 839a x2 O 10-14-2021 839ax7 10-14-2021 1 1 MD345 1 1 A 1 Location of Crane 2 SEND CHANGES TO TARA 3 771/21 - Update in progress 8-2-2021 4 Gilbert Yard - AZ 5 Southwest Yard - AZ 6 Colton Yard - CA 7 Dielco Yard - NV 10-14-2021 8 Sloan Yard - NV 9 Shady Grove, PA 10 Denver Yard - CO 11 Denver Yard - CO 10-14-2021 12 Duffy . CO 10-14-2021 13 TCR md485 - CO 10-14-2021 14 UT Freight Yard - UT 15 Reno Student Housing. UT 16 Chasse - The Haverly - AZ????? Dismantled 17 TDC Park Central - AZ DISMANTLED 18 Union on 6th??????? 19 Colt - Kierland #1??????? 20 McShane 21 1320 E Jefferson - CA 22 Little Tokyo (lotus) - CA 6006 23 Ferrante #1 - CA 24 Ferrante #2 - CA 25 Ferrante #3 - CA 26 Webcor - 960 7th St - CA 27 Webcor - 960 7th St - CA 28 Webcor - Bay Meadows #1 - CA 29 Etco - Palm Drive - CA 30 CA-Webcor - Bay Meadows #5 31 AZ-Colt - Clarendale 1 1 7 1 1 1 1 1 MD485 MDT178 Wolff - 8033 MDT98 Wolff MDT139 MCT88 MDT302 MD485 MD485 MR418 MD569 MD485 MDT98 Wolff - 8033 MDT98-6104 3 1 1 13 1 1 Sheet view workbook Views Show zoom window Ma X =SUMPRODUCT(('Tower Crane Mast Inventory'!B4:AN31)*('Tower Crane Mast Inventory'!B1:AN1=$D$29) *('Tower Crane Mast Inventory'!A4:A31-B33)) B C E F G H K M N 0 Crane? Location Gilbert Yard - AZ # of Equipment 52 0 Equipment List For Location P800B Fishplates P850A Fishplates Anchor Stool Fishplates P802A V60 Chassis 6m cross base ZX6830 6.0m cross base ZD4230 4.5m cross base ZD2030 4.5m cross base | ZC2030 3.8m cross base 1 KRMT849C (3.3m) K850/KR800B (10m) K849/K849 (2m) KMRT849A-2 KRMT849A 40 KM850.10A (5m) KRMT839A (5m) KM850.10B (10m) KM850.10E (10m) S24E-1 S24E-2 SR24E-1 SR24E-2 - SR26E-1 SR26E-2 SR25F-1 (7m) 1 1 1 1 SR25F-Yellow K437A (5m) K437 E or B (10m) K447E (10M) K449A (5M) KRMT639A K649A Yello K649A K60/K60 K60/K40 K40/K20 Wolff TV.20 7 161-30-050 Wolff X-Base Equipment Look Up KRMT849A Number of Equipment Location of Euipment Denver Yard - CO Gilbert Yard - AZ Southwest Yard - AZ #VALUE! Colton Vard CA B Crane D E F G H Anchor Stool Fishplates P802A P800B Fishplates P850A Fishplates V60 Chassis 6m cross base ZX6830 6.0m cross base ZD4230 4.5m cross base ZD2030 4.5m cross base ZC2030 3.8m cross base KRMT849A K M N KRMT839A (5m) KRMT849C (3.3m) K850/KR800B (10m) 1 40 1 1 2 18 27 2 30 9 849a2 x2, 839a x2 O 10-14-2021 839ax7 10-14-2021 1 1 MD345 1 1 A 1 Location of Crane 2 SEND CHANGES TO TARA 3 771/21 - Update in progress 8-2-2021 4 Gilbert Yard - AZ 5 Southwest Yard - AZ 6 Colton Yard - CA 7 Dielco Yard - NV 10-14-2021 8 Sloan Yard - NV 9 Shady Grove, PA 10 Denver Yard - CO 11 Denver Yard - CO 10-14-2021 12 Duffy . CO 10-14-2021 13 TCR md485 - CO 10-14-2021 14 UT Freight Yard - UT 15 Reno Student Housing. UT 16 Chasse - The Haverly - AZ????? Dismantled 17 TDC Park Central - AZ DISMANTLED 18 Union on 6th??????? 19 Colt - Kierland #1??????? 20 McShane 21 1320 E Jefferson - CA 22 Little Tokyo (lotus) - CA 6006 23 Ferrante #1 - CA 24 Ferrante #2 - CA 25 Ferrante #3 - CA 26 Webcor - 960 7th St - CA 27 Webcor - 960 7th St - CA 28 Webcor - Bay Meadows #1 - CA 29 Etco - Palm Drive - CA 30 CA-Webcor - Bay Meadows #5 31 AZ-Colt - Clarendale 1 1 7 1 1 1 1 1 MD485 MDT178 Wolff - 8033 MDT98 Wolff MDT139 MCT88 MDT302 MD485 MD485 MR418 MD569 MD485 MDT98 Wolff - 8033 MDT98-6104 3 1 1 13 1 1