Can't get wall component to calculate in worksheet

[taoist]

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

[taoist]

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?