I'm new to this type of thing (posting messages). I'm trying to create a formula(s) that will give me the area of a home with many exterior sides. The worksheet will allow for the direction of the wall; up, down, left or right, and the length of each wall.

The shape I am using goes something like this: Up 3, Right 1, Up 2, Right 2, Up 1, Right 2, Down 2, Right 2, Down 4, Left 2, Up 1 , Left 1, Up 1, Left 1, Down 1, Left 1, Down 1, and Left 2.

I know it is a complex shape, but all angles are right angles, so it shouldn't be impossible, not that anything is impossible. Common sense says just to do it my head and write it down, but the program is for my neighbor, and I want to make it as simple as possible.

Thanks Brad