I have a workbook where I need to figure out how to set a formula that allows for Length x Width x Height of multiple areas at once and will compute into one area. For example I have one row for the basement room. Instead of it just being 10 x 12 x 8. It is 10 x 12 x8 + 2 x 6 x8 + 15 x 10 x 8. How do I get the math to represent the Square footage correctly?

Secondly, I need to set up a formula where If there is data in C102 on one page then the cell C57 on the previous page needs to pull that data, if there isn’t any data in C102 then it needs to pull the information in cell C101. However I always need cell C103 to be represented in cell D57

Lastly, I need to create an automated audit page that will detect any errors or missing information thorughout the workbook in a summarized fashion.

It has to be created without macros or Visual Basics as it is used on an iPad almost exclusively.

On the formula I can only seem to get the regular L x W x H to calculate accurately.

The things I have tried result in the cell C57 being correct most of the time but D57 is never write.

I haven’t attempted the audit sheet as I don’t even know how to go about it.