G
Guest
Here's what I want to do…I cannot get the formula to work
If you see "NTS" in cells B5:B12, SUMPRODUCT the length times the units and
put the result in cells F17:H17. Then, make the same calculation for the
other braider types.
B
Braider Units
Type Length April May June
NTS 50 10 5 50
DBL/STD 75 20 10 40
OTH 25 30 15 30
NTS 65 40 20 20
NTS 70 50 25 20
HLX 130 10 30 15
HLX 50 20 35 80
DBL/STD 50 30 40 10
NTS If column b is NTS then sumproduct(length * units)
DBL/STD
HLX
DBL/STD
If you see "NTS" in cells B5:B12, SUMPRODUCT the length times the units and
put the result in cells F17:H17. Then, make the same calculation for the
other braider types.
B
Braider Units
Type Length April May June
NTS 50 10 5 50
DBL/STD 75 20 10 40
OTH 25 30 15 30
NTS 65 40 20 20
NTS 70 50 25 20
HLX 130 10 30 15
HLX 50 20 35 80
DBL/STD 50 30 40 10
NTS If column b is NTS then sumproduct(length * units)
DBL/STD
HLX
DBL/STD