help

[amolryeolekar]

is it possible to sum the wt column having grade column= "d" ,next stage
column= "al" & "at , & " ec" having thickness range is between <1.2 &

0.3 mm .

random dfata can be considered with diffrent thickness,grade,wt

by using counif,sumif,if formula


pl help

from :amol Email:[email protected]

 

[Dick Kusleika]

amol

Probably, but it would be easier to use an array formula.

wt=A
grade=B
next stage = C
thickness = D

=SUM((B1:B100="d")*((C1:C100="al")+(C1:C100="at")+(C1:C100="ec"))*(D1100<1
..2)*(D1100>.3)*(A1:A100))

enter with control+shift+enter, not just enter. Excel will put curly braces
around the formula if you enter it right.