# How to sum by category in Google Sheets

Sometimes, we need to sum by a category in Google Sheets.

We can use SUMIF function, SUMIFS function and UNIQUE function for this.

## 2 Methods to sum by category in Google Sheets

• Summing according to a given range using SUMIF
• Summing according to a given range using UNIQUE and SUMIF

## Method 1: Summing according to a given range using SUMIF

For instance, let’s take the following dataset. We wish to calculate units per item sold. Now, the items are of four categories in total.

We have a pencil, binder, desk, desk-set.

### Step 1: Applying the SUMIF function.

The syntax of SUMIF function is

``= SUMIF(range, criterion, [ sum_range])``

Here,

range represents the range of cells containing all the categories,

criterion represents the category to be summed,

sum_range represents the values to be summed by the particular category..

For this instance, to find out the total units of pencils, we use

``SUMIF( D2:D44, “PENCIL”, E2:E44).``

Similarly, to find the total units of another category, we simply replace pencil with that category. To get the total units of pens, we use SUMIF( D2:D44, “PEN SET”, E2:E44).

## Method 2: Summing according to a given range using UNIQUE and SUMIF functions

### Step 1: Finding the categories using the UNIQUE function.

Let’s take the same  example.

The UNIQUE function’s syntax is

``=UNIQUE( range of data, [by column], [ exactly_once]}``

Here we need to know the different categories of items in the dataset.So, syntax is

``=UNIQUE( D2:D44).``

The column gets populated with the list of unique categories. In this case, there are five options.

### Step 2: Totalling value per category using SUMIF.

The syntax of SUMIF function is

``= SUMIF(range, criterion, [ sum_range]).``

For pencil, we use = SUMIF(D2:D44, I2, E2:E44).

You will get a Suggested autofill prompt. Click the tick icon to accept the autofill.

We get the result as such.

## Conclusion

We hope these methods have helped you. Let us know in the comments below.