# Sum array values

**URL:** <https://discourse.nodered.org/t/sum-array-values/28664>\
**Category:** General\
**Created:** [20 June 2020 17:33 UTC](https://discourse.nodered.org/t/sum-array-values/28664 "2020-06-20T17:33:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ghayne](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ghayne/32/39_2.png) [@ghayne](https://discourse.nodered.org/u/ghayne)\
**Post date:** [20 June 2020 17:33 UTC](https://discourse.nodered.org/t/sum-array-values/28664/1 "2020-06-20T17:33:23Z")

</div>

I have an array that looks like:

```auto
0: object
time: "2020-06-18T23:00:00.000Z"
consumption_value_inc_vat: 0.498036
1: object
time: "2020-06-18T23:30:00.000Z"
consumption_value_inc_vat: 0.4657905
....................

```

How can I sum the "consumption\_value\_inc\_vat"?  
Preferably in JSONata.

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [20 June 2020 20:36 UTC](https://discourse.nodered.org/t/sum-array-values/28664/2 "2020-06-20T20:36:14Z")

</div>

assuming that that is msg.payload, try `$sum(payload.consumption_value_inc_vat)`

---

<div class="post-metadata">

**Author:** ![ghayne](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ghayne/32/39_2.png) [@ghayne](https://discourse.nodered.org/u/ghayne)\
**Post date:** [20 June 2020 20:47 UTC](https://discourse.nodered.org/t/sum-array-values/28664/3 "2020-06-20T20:47:05Z")

</div>

Thanks Paul, I had a brainfart trying to do this, overthinking!!!!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [4 July 2020 20:47 UTC](https://discourse.nodered.org/t/sum-array-values/28664/4 "2020-07-04T20:47:10Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.