Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|