DSUM I Think

muledalton · May 1st, 2002, 07:22 AM

I have 2 sheets in my workbook. The second sheet is an inventory count sheet that contains columns for Category, Extended Price, etc. I need a function or formula to be able to calculate the totals of each category to the first page. Thanks for your help!

[ This Message was edited by: muledalton on 2002-05-01 06:23 ]

Aladin Akyurek · May 1st, 2002, 07:51 AM

Consider using Pivot Tables.

A formula-based approach would be to use SUMIF for totals per Category. If you want to carry out a multiconditional breakdown, try to use SUMPRODUCT. An alternative is DSUM which requires you to set up a criterion range every time it must be applied.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 07:22 AM	#1
muledalton New Member Join Date: Apr 2002 Location: Darrin Davis Posts: 3	I have 2 sheets in my workbook. The second sheet is an inventory count sheet that contains columns for Category, Extended Price, etc. I need a function or formula to be able to calculate the totals of each category to the first page. Thanks for your help! [ This Message was edited by: muledalton on 2002-05-01 06:23 ]

May 1st, 2002, 07:51 AM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	Consider using Pivot Tables. A formula-based approach would be to use SUMIF for totals per Category. If you want to carry out a multiconditional breakdown, try to use SUMPRODUCT. An alternative is DSUM which requires you to set up a criterion range every time it must be applied.