Calculate the total on cells under a specific category

Asked By kary hart 0 points N/A Posted on - 07/10/2013

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.

• Status: Open
• Question Views: 849
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By donald hall 0 points N/A #125620

Calculate the total on cells under a specific category

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.

About donald hall

Questions
4

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/10/2013
• Question Category: MS Excel