Drop down list sum

[tissue]

Hello everyone,
I have two worksheets, one is the summary sheet and the other is where all the data are entered.

In the 'data entry' worksheet, there are tables which shows what products were sold on each day.
So for the month February, there will be 28 tables.
Each table consists of three columns. The left most column contains a drop down list of the categories of products, ex: Sweets, Drinks, Pastry. The column next to it is where the product name is entered manually, and the other column the amount of product sold.

In the 'summary' worksheet, there's a table with 2 columns. The first column shows the categories: Sweets, Drinks, Pastry, and the second column displays the total amount of each category sold in the month.
What I want is in this worksheet, a function to calculate the total amount for each category that were sold based on the data entered in the other worksheet.

Thanks in advance!

 

[Robert Mika]

Maybe formula from this topic?

http://www.excelforum.com/excel-wor...mif-function-can-it-sum-multiple-columns.html

Which in your case coudl be somethig like that:

=SUM(IF(A5:A11=A3,$B5:$AB11))

Array formula confirm CTRL+SHIFT+ENTER

 

[mikerickson]

How about, in Sheet2!B3

=SUMIF(Sheet1$A:$DT, A3, Sheet1!$C:$DV)

 

[tissue]

Thank you both Robert Mika and mikerickson,
it worked!