Expense Sheet help

**sukhdeepsinghkohli** · 09-11-2011, 01:46 AM

Hi

I am looking for some help in Excel 2010.

Column 1 - Contains the Item
Column 2 - Contains the Amount
Column 3 - Contains the Salesman

At the bottom, i need Totals of Amount of a Particular Sales. I have attached the sheet without Formulas.

Appreciate your help

**gjlindn** · 09-11-2011, 01:52 AM

Put this formula in cell B13 and copy it down

Please Login or Register  to view this content.

**MarvinP** · 09-11-2011, 02:18 AM

Hi sukhdeepsinghkohli and welcome to the forum,

Pivot Tables were made for your kind of problem. See the attached with the answer.
see http://office.microsoft.com/en-us/ex...001034632.aspx

Note - No formulas are needed if you know how to use Pivot Tables!