LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Formula for the subtotal

i need to know how to calculate of the subtotal for below:

A B C D E F
Year Quater Week Department Agent Action
2005 1 1 Sales Fanny No
2005 1 1 Sales Fanny Yes
2005 1 1 Sales Fanny TBA
2005 1 1 Sales Fanny No
2005 1 1 Sales Fanny No

Subtotal for the Agent's action.
For example
Fanny - No : 3, Yes = 1...etc

Your help is much appreciated. Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotal and IF Formula MP Excel Discussion (Misc queries) 1 May 7th 09 08:55 PM
Using a Max Subtotal a Formula LindaD Excel Worksheet Functions 5 October 3rd 08 09:11 AM
Subtotal Formula Chris Excel Worksheet Functions 1 August 31st 08 06:56 AM
Subtotal Formula Pat[_2_] Excel Worksheet Functions 7 November 7th 07 05:12 PM
Formula Help - If and Subtotal(???) Evan Excel Discussion (Misc queries) 4 October 18th 07 04:26 PM


All times are GMT +1. The time now is 06:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"