# Thread: Need help to calculate Square Footage in Microsoft Excel

1. Member
Join Date
Jun 2011
Posts
21

## Need help to calculate Square Footage in Microsoft Excel

I want to create a spreadsheet so that I can enter measurements for a house & have the total square footage displayed. I am having issues with the calculations due to feet & inches. Any suggestions or tips.

2. Member
Join Date
Feb 2009
Posts
107

## Re: Need help to calculate Square Footage in Microsoft Excel

You must use the format "number" to calculate how many hours you need to know the unit. Basically there is no exact formula to do this. But you can make the same if you know the entire calculation how square feet works. You cannot directly find a reference in Excel. There are other ready to use calculator for this which you can download for free and use.

3. Member
Join Date
Nov 2009
Posts
61

## Re: Need help to calculate Square Footage in Microsoft Excel

I have a very short example that might help you. In cell A2 put the square meters. Then in cell B2 put the hour. Then the formula in cell B3 will be = B2/A2. The cells are formatted as numbers, entered as decimal hours (5 hours and 15 minutes to write 5.25). Length times width gives the area, whether in mm ², cm ² or m². Also you can specify the inches to meters.

4. Member
Join Date
Apr 2014
Posts
1

## Re: Need help to calculate Square Footage in Microsoft Excel

I need help creating a formula in excel to Calculate square footage this is what I have.
lot width (front) 18.41
lot width (back) 15.00
lot Lenght (right) 25.00
Lot Lenght (back) 25.00

5. Member
Join Date
Dec 2007
Posts
2,291

## Re: Need help to calculate Square Footage in Microsoft Excel

Originally Posted by eflores
I need help creating a formula in excel to Calculate square footage this is what I have.
lot width (front) 18.41
lot width (back) 15.00
lot Lenght (right) 25.00
Lot Lenght (back) 25.00
You can go with the VBA answer so that the formula is atleast readable. Below is a new function called SQFT() which you can add to your workbook to make it easy:

Code:
```Function SQFT(RNG As Range) As Single
'Convert text strings like 12'5"x10'6" into square footage
If RNG.Cells.Count > 1 Then
SQFT = "1 cell only"
Exit Function
End If

Dim MyArr, i As Long

MyArr = Split(Replace(Replace(Replace(Replace(RNG, "'", "^"), " ", ""), """x", "^"), """", "^"), "^")

SQFT = ((MyArr(0) * 12) + MyArr(1)) * ((MyArr(2) * 12) + MyArr(3)) / 144
End Function```