Calculating subtotals for consultants

**jonbennett84** · 01-02-2013, 09:16 AM

Hello

I'm trying to find a way to calculate subtotals per consultant automatically as well as the total, like the attached image, without having to do filters.

Attachment 203460

Thanks Jon

**dilipandey** · 01-02-2013, 09:22 AM

Hi Jon,

Welcome to the forum.
Your attachment is not working.. if that is an image, suggest you to upload a sample workbook with your expected results. thanks.

Regards,
DILIPandey
<click on below * if this helps>

**jonbennett84** · 01-02-2013, 09:24 AM

Thanks DILIPandey

Here's the link to the spreadsheet.

https://docs.google.com/open?id=0BzG...1M1M3dJclI0bjQ

Regards Jon

**dilipandey** · 01-02-2013, 09:29 AM

Okay.. use below formula:-

Formula:

Please Login or Register  to view this content.

see attached:- test.xls

Regards,
DILIPandey
<click on below * if this helps>

**olasa** · 01-02-2013, 09:31 AM

Or try =SUMIF(A2:A10,"Dave",C2:C10)
//Ola

**jonbennett84** · 01-02-2013, 09:37 AM

Brilliant thanks guys - appreciate the quick replies

**dilipandey** · 01-02-2013, 09:38 AM

You are welcome Jon..

Cheers

One more thing.. if you like to have totals while you do filtering on the data, then try looking at SubTotal function

Regards,
DILIPandey
<click on below * if this helps>

**olasa** · 01-02-2013, 09:44 AM

You could also have a look at something called PivotTables.
If you want to try, Select your data table and select in the Menu:Insert>PivotTable.
//Ola