How to Calculate Area of Irregular Shape in Excel (3 Easy Methods)

To illustrate the calculations, we will use the sample dataset below.


Method 1 – Determine Area of Irregular Shape by Simple Calculation in Excel

STEPS:

  • Select cell E5.
  • Enter the formula:
=C5*D6
  • Press Enter.
  • AutoFill tool till the 4th vertex.
  • You’ll get the output as shown in the image.

Determine Area of Irregular Shape by Simple Calculation in Excel

  • In cell E9, enter the formula:
=C9*D5
  • Press Enter.

Determine Area of Irregular Shape by Simple Calculation in Excel

  • Select cell F5 and enter the formula:
=D5*C6
  • Press Enter and AutoFill till the 4th vertex.

Determine Area of Irregular Shape by Simple Calculation in Excel

  • In cell F9, enter the formula:
=D9*C5
  • Press Enter.

Determine Area of Irregular Shape by Simple Calculation in Excel

  • AutoSum cells E10 and F10.
  • It returns the sum of the respective columns.

Determine Area of Irregular Shape by Simple Calculation in Excel

  • In cell D12, enter the formula:
=ABS(E10-F10)/2
  • Press Enter to get the area of the irregular shape.

Determine Area of Irregular Shape by Simple Calculation in Excel


Method 2 – Insert Excel SUMPRODUCT Function to Calculate Area of Irregular Shape

STEPS:

  • In cell E5, enter the formula:
=SUMPRODUCT(C5:C9,D6:D10)
  • Press Enter to return the output.

  • Select cell F5, and enter the formula:
=SUMPRODUCT(D5:D9,C6:C10)
  • Press Enter.

  • In cell D12, enter the formula:
=0.5*ABS(E5-F5)
  • Press Enter to return the output.


Method 3 – Create Array Formula in Excel for Computing Irregular Shape Area

STEPS:

  • Select cell D12, enter the formula:
=0.5*ABS(SUM(C5:C9*D6:D10-D5:D9*C6:C10))
  • Press Enter to get the Irregular Shape Area.

How Does the Formula Work?

  • C5:C9*D6:D10

Cells in the range C5:C9 get multiplied by cells in the range D6:D10.

  • D5:D9*C6:C10

Cells in the range D5:D9 get multiplied by cells in the range C6:C10.

  • SUM(C5:C9*D6:D10-D5:D9*C6:C10)

The SUM function totals the output of C5:C9*D6:D10-D5:D9*C6:C10.

  • 5*ABS(SUM(C5:C9*D6:D10-D5:D9*C6:C10))

The absolute value of the SUM function output is multiplied by .5.


Download Practice Workbook


<< Go Back to Formula List | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Aung Shine
Aung Shine

Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo