Calculation Issues

How to Total Acre and Gunta Values Using Excel Formulas

Bushra Parveen Oct 16, 2026 870 views

Question details

The user needs to sum up land measurement values represented in acres and guntas (e.g., 2.35 for 2 acres and 35 guntas), ensuring the calculation accounts for 40 guntas making up 1 acre.

How to Calculate the Total of Acre and Gunta Values in Excel

Product: Excel
Device & OS: not provided
Scenario: Adding up multiple land measurement entries recorded in a decimal format where standard base-10 addition yields incorrect results.
Observed behavior: Standard sum formulas calculate using base-10 logic, causing inaccurate totals for units that use a base-40 conversion system.

Before you start

Ensure your data is entered consistently using the decimal format (e.g., 2.35 for 2 acres and 35 guntas), and verify that the decimal component in any single cell does not exceed 39.

Solution 1Recommended

Use the LET and SUMPRODUCT Functions

This method efficiently calculates the total in a single formula by converting everything to guntas, summing them, and converting the final result back to the acre.gunta format.

This formula uses the LET function to store intermediate calculations, making the formula cleaner and easier to read. It requires a modern spreadsheet software version that supports the LET function.

Select the target cell

Click on the cell where you want the final acre and gunta total to be displayed.

Input the calculation formula

Type the formula: =LET(g,SUMPRODUCT(INT(A2:A6)*40+(A2:A6-INT(A2:A6))*100),INT(g/40)+MOD(g,40)/100). Replace A2:A6 with the actual cell range containing your values.

Execute the formula

Press the Enter key. The cell will now display the accurate total in the acre.gunta format.

Formula Breakdown: The INT function separates the acres, while multiplying by 40 converts them to guntas. The MOD function helps translate the final raw gunta total back into the appropriate decimal display.

Solution 2

Use SUMPRODUCT for Older Versions

If your spreadsheet application does not support the LET function, you can use standard SUMPRODUCT combined with INT and MOD to achieve the same accurate summation.

Advanced Formulas Made Easy

Easily Calculate Complex Land Measurements in WPS Spreadsheet

WPS Office Spreadsheet fully supports advanced array formulas, SUMPRODUCT, and modern mathematical functions required for specialized regional calculations like Acres and Guntas.

1. Open your dataset: Launch WPS Spreadsheet and open the workbook containing your land measurement data.
2. Apply the conversion formula: Select the total cell and paste the provided SUMPRODUCT formula to handle the base-40 gunta conversion.
3. Calculate instantly: Press Enter to instantly view your precisely calculated totals without complex manual conversions.

Fully compatible with Microsoft Excel formulas and number formattingSupports advanced functions like SUMPRODUCT, INT, and MOD nativelyFree, lightweight, and easy to use for daily land surveying calculationsSeamlessly migrate your existing Excel workbooks without losing data integrity

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I just use the basic SUM function for acres and guntas?

The standard SUM function uses base-10 mathematics. Because 1 acre strictly equals 40 guntas, regular addition will incorrectly carry over at 100 instead of 40, resulting in mathematically inaccurate land totals.

What does the INT function do in this specific formula?

The INT function extracts the integer part of the number, which represents the acres. This separates the acres from the decimal part (guntas), allowing the formula to convert the acres into guntas before adding everything up.

What happens if a gunta value in my data is typed as .40 or higher?

If a gunta value is entered as 40 or higher (e.g., 2.45), the mathematical conversion will be skewed, as .40 should technically carry over as a full acre. It is highly recommended to use Data Validation to ensure the decimal part never exceeds .39 during entry.

Excel & Data Problems