2006-02-11, 03:53 PM
I've created a table which has several fields linked to other information in the file. They are: room title, layer name and area. In another column, I've typed in different dollar values for dollars per square foot. In another column of cells, I've created a formula that multiplies each room's area, by the dollar amount per square foot for that room to give me the final pricing value for the floor material of that room. Finally, I'm adding up those final pricing values to find the total cost of all rooms. The formula is set up correctly, but it is coming up with a number that is totally off. I've attached the file to this post.