help
 

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 :rolleyes:


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

help
 

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"))*(D1:D100<1
..2)*(D1:D100.3)*(A1:A100))

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

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"amolryeolekar" wrote in message
...

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 :rolleyes:


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/