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.

Login/Register to Answer

Related Questions