# CakePHP 4 Sum column value

> This tutorial is a very short one. How to sum the value from a column in a table? Let say you’ve table stocks [id, product, brand, quantity]. To sum the quantity value, you can apply the following code to your controller.

- URL: https://codethepixel.com/codethepixel/public/cakephp-4-sum-column-value
- Author: Asyraf Wahi Anuar (https://codethepixel.com/codethepixel/public/author/asyraf-wahi-anuar)
- Published: 2021-06-03
- Updated: 2021-11-11
- Category: CakePHP
- Tested with: CakePHP 4.x
- Tags: CakePHP, Count, Sum
- Reading time: 1 min

This tutorial is a very short one. How to sum the value from a column in a table? Let say you’ve table stocks \[id, product, brand, quantity\]. To sum the quantity value, you can apply the following code to your controller.

```php
public function index()
{
    $stocks = $this->paginate($this->Stocks);
    //Count quantity
    $total_quantity = $this->Stocks->find();
    $count_quantity =$total_quantity->select(['sum' => $total_quantity->func()->sum('Stocks.quantity')])->first();
    $sum_quantity = $count_quantity->sum;

    $this->set(compact('stocks','sum_quantity'));
}
```

You can print the result using the following code in your view.

```php
<?= $sum_quantity; ?>
```

That’s all. Happy coding :)