# Material Areas/List Combination Question

**URL:** <https://forum.dynamobim.com/t/material-areas-list-combination-question/1870>\
**Category:** Packages\
**Created:** [July 26, 2015, 11:28pm UTC](https://forum.dynamobim.com/t/material-areas-list-combination-question/1870 "2015-07-26T23:28:42Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brendan\_Laurence](https://avatars.discourse-cdn.com/v4/letter/b/6a8cbe/32.png) [@Brendan\_Laurence](https://forum.dynamobim.com/u/Brendan_Laurence)\
**Post date:** [July 26, 2015, 11:28pm UTC](https://forum.dynamobim.com/t/material-areas-list-combination-question/1870/1 "2015-07-26T23:28:42Z")

</div>

Hi all,

Im trying to get material areas & volumes out to excel, but have hit the limit of my knowledge.

Essentially I want to calculate the TOTAL area of each material rather than the area of each element with that material (imagine that “itemize every instance” is unchecked in the schedule) and take that value, along with the material name, into excel.

At the moment the only way I can figure is to extract that data through the Element.Materials Package node, which is fine. But how do I recombine those lists to sum up the areas of the duplicate material names ie, wall one has materials A,B & C but Wall Two has materials A & C. How do I find the sum of A, B & C based on the material name?

Is there a good place to learn about the various ways to manipulate Dynamo lists, or is this a Python learning point?

&nbsp;

Thanks for your advice.

---

<div class="post-metadata">

**Author:** ![Sam\_Dehghani](https://avatars.discourse-cdn.com/v4/letter/s/e274bd/32.png) [@Sam\_Dehghani](https://forum.dynamobim.com/u/Sam_Dehghani)\
**Post date:** [November 11, 2015, 7:19am UTC](https://forum.dynamobim.com/t/material-areas-list-combination-question/1870/2 "2015-11-11T07:19:50Z")

</div>

Hello Brendan

I had the same problem in finding the total area of a material. Did you find any answer?

---

<div class="post-metadata">

**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\
**Post date:** [November 12, 2015, 1:32am UTC](https://forum.dynamobim.com/t/material-areas-list-combination-question/1870/3 "2015-11-12T01:32:12Z")

</div>

Hi Brendan & Sam,

Below is the answer your looking for Sum Material Areas by there names. Good Luck!

 ![Material areas](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/2X/a/a7c5977a9f178baf3ca0c8d2aa7626e80735c818.png)

---

<div class="post-metadata">

**Author:** ![Sam\_Dehghani](https://avatars.discourse-cdn.com/v4/letter/s/e274bd/32.png) [@Sam\_Dehghani](https://forum.dynamobim.com/u/Sam_Dehghani)\
**Post date:** [November 14, 2015, 6:05am UTC](https://forum.dynamobim.com/t/material-areas-list-combination-question/1870/4 "2015-11-14T06:05:11Z")

</div>

Hi Kulkul

Thank you so much for your quick and accurate response. Cheers!

---

<div class="post-metadata">

**Author:** ![Tchama\_Victorine](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tchama\_Victorine](https://forum.dynamobim.com/u/Tchama_Victorine)\
**Post date:** [January 11, 2016, 10:29am UTC](https://forum.dynamobim.com/t/material-areas-list-combination-question/1870/5 "2016-01-11T10:29:09Z")

</div>

please can someone help me? i have done all the procedure how can it export /get the schedule into revit? thank you

---

<div class="post-metadata">

**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\
**Post date:** [January 11, 2016, 10:38am UTC](https://forum.dynamobim.com/t/material-areas-list-combination-question/1870/6 "2016-01-11T10:38:21Z")

</div>

Hi Tchama,

Where are you looking to export in Revit? Are you trying to create schedule.

---

<div class="post-metadata">

**Author:** ![Tchama\_Victorine](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tchama\_Victorine](https://forum.dynamobim.com/u/Tchama_Victorine)\
**Post date:** [January 11, 2016, 3:30pm UTC](https://forum.dynamobim.com/t/material-areas-list-combination-question/1870/7 "2016-01-11T15:30:15Z")

</div>

@KULKUL, PLEASE I’LL LIKE TO EXPORT IN EXCEL OR CREATE A SCHEDULE IN REVIT …THANK YOU

---

<div class="post-metadata">

**Author:** ![Tchama\_Victorine](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tchama\_Victorine](https://forum.dynamobim.com/u/Tchama_Victorine)\
**Post date:** [January 12, 2016, 6:12am UTC](https://forum.dynamobim.com/t/material-areas-list-combination-question/1870/8 "2016-01-12T06:12:08Z")

</div>

Hi everyone!

this is the sollution

 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/1X/fe2e300061fda245e7cc53a35298901184e13204.png)
