taoist 19 Posted June 30, 2013 (edited) I am creating a worksheet for wall material takeoff. Wall length reports OK Wall height reports OK Wall area reports OK I need to report area of drywall. I am using componentarea function. I am having trouble having it report what I want. I figure it is something I am not doing correctly, or I am not using the needed function. I have the wall components defined by class. I noticed there is an index needed. Does this represent the order of wall components from top to bottom as one defines a wall style? Edited July 1, 2013 by taoist Quote Share this post Link to post
taoist 19 Posted July 2, 2013 I managed to get it working, sort of. =COMPONENTAREA(((WST='Int-2x4-Gyp Bd 1/2')), 1) I placed a stylized wall 9' tall, 1/2" GWB, 2x4 stud, 1/2" GWB Reports wall area OK using wallarea_gross function. Reports 0 using componentarea function. I assume, the number 1 in this case refers to the 1st wall component. I need to get this to work for drywall takeoff. Any ideas? Quote Share this post Link to post