Subtotal with additional criteria

[Danni2004]

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

 

[Spiky]

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,***).