DSUM I Think

[muledalton]

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]

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.