Calculate the total on cells under a specific category

Asked By 0 points N/A Posted on -
qa-featured

I want to calculate the total price of a certain category on my Excel worksheet. Sample image is provided below:

How can I calculate the Prices on the category of Pencil? I just want the total price for all the pencils on column B. Thanks in advance.

SHARE
Answered By 0 points N/A #125620

Calculate the total on cells under a specific category

qa-featured

In this case, you will need to use the SUMIFS() function in Excel to calculate the total prices on a column under the same category. Say, you are looking for the total prices of all the pencils on column A, just insert the formula listed below on a cell where you want the result to appear.

Formula:

=SUMIFS(A3:A10,B3:B10,"=pencil")

You can use the same formula for other category, just change the value of "pencil" to "paper" if you want to calculate the total prices of the paper category.

Related Questions