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.
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.