Just after I finished How to Report and Analyze Variable-Length Databases in Excel a visitor asked how to use formulas to show subtotals in a sorted list. From her description, she wants to do something like this:
Excel formulas calculate the subtotals in this list.
In this figure, I set up the aaCustCode and aaAmount range names as I described in How to Report and Analyze Variable-Length Databases in Excel. Here’s the new formula for the cell shown:
C5: =IF($A5=$A6,”",SUMPRODUCT((aaCustCode=$A5)*aaAmount))
Copy this formula to the range C6:C9. As more data is added, copy it down the column as needed.
{ 1 comment }
Thanks! We’ll sure try this out.
Comments on this entry are closed.