Hi,
need assistance on this code
=SUMIFS(rway_bom!$A$1:$A$50,"TRAY",rway_bom!$B$1:$B$50,"straight",rway_bom!$E$1:$E$50,"8"=sum(rway_bom!$D$1:$D$50))
after all the criteria is met i want to add the total
rway_bom (data sheet)
sheet 1 is where i want to total to show
(rway_bom)
a1 to a50 looks for TRAY (criteria 1)
b1 to b50 looks for straight (criteria 2)
e1 to e50 looks for 8 (criteria 3)
if all is met
d1 to d50 add all for total to be shown on sheet 1
Help
Bookmarks