IF STMNTWITH SUMPRODUCT ARRAY
 

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 STMNTWITH SUMPRODUCT ARRAY
 

Units for ALL the months (April,May,June) or just a single month?

"Cfiore" wrote:

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 STMNTWITH SUMPRODUCT ARRAY
 

For JUNE:

=SUMPRODUCT(--($B$2:$B$9="NTS")*($C$2:$C$9)*($F$2:$F$9))


OR

=SUMPRODUCT(--($B$2:$B$9=B20)*($C$2:$C$9)*($F$2:$F$9))

where B20="NTS"

Column C is length
Column F i units for June


Adjust ranges to suit

HTH
"Cfiore" wrote:

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