Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal with additional criteria
Hi-
I am looking for a subtotal formula that will adjust with autofilter. What is stumping me is that the formula needs to be based on the additional criteria of weekday. Here is an example of my data: Region Weekday PersonID Area Mgr 6am 7am 8am 1 TUES 165236 A. Bizzaro 1 1 0 1 TUES 156271 A. Bizzaro 1 1 1 5 MON 151897 R. Waite 1 0 0 5 MON 158269 R. Waite 0 1 1 5 TUES 168895 R. Waite 0 0 0 6 MON 169095 M. Carter 1 1 1 6 SUN 169095 M. Carter 0 1 1 8 SUN 151592 J. Lath 0 0 1 MONDAY 2 2 2 TUESDAY 2 2 1 SUNDAY 0 1 2 So if the Area Manager wants to filter just their own name or if a director wants to filter just a region, the subtotals for each day would adjust with that. Would prefer to use a formula rather than pivot tables. Any help would be greatly appreciated! Thanks! Danni |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal with additional criteria
On Apr 23, 11:22 am, Danni2004
wrote: Hi- I am looking for a subtotal formula that will adjust with autofilter. What is stumping me is that the formula needs to be based on the additional criteria of weekday. Here is an example of my data: Region Weekday PersonID Area Mgr 6am 7am 8am 1 TUES 165236 A. Bizzaro 1 1 0 1 TUES 156271 A. Bizzaro 1 1 1 5 MON 151897 R. Waite 1 0 0 5 MON 158269 R. Waite 0 1 1 5 TUES 168895 R. Waite 0 0 0 6 MON 169095 M. Carter 1 1 1 6 SUN 169095 M. Carter 0 1 1 8 SUN 151592 J. Lath 0 0 1 MONDAY 2 2 2 TUESDAY 2 2 1 SUNDAY 0 1 2 So if the Area Manager wants to filter just their own name or if a director wants to filter just a region, the subtotals for each day would adjust with that. Would prefer to use a formula rather than pivot tables. Any help would be greatly appreciated! Thanks! Danni Change the formula from =SUBTOTAL(9,***) to =SUBTOTAL(109,***). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT - Additional criteria | Excel Worksheet Functions | |||
Counting unique records with additional criteria | Excel Worksheet Functions | |||
Count Unique Names in list w/ Additional Criteria? | Excel Worksheet Functions | |||
SUBTOTAL and then count with criteria | Excel Worksheet Functions | |||
SUMIF/COUNTIF with an additional criteria | Excel Worksheet Functions |