C
Clive_S
Hi
I have a table with a number of values.
Each person is assigned a unique attribute (identifier), zone (1 -
43), gender and employment (full or part time)
Pivot only gives 21 or 22
I want to count the following.
All full time men in Zone 1 & get a double (21.5)
All part time men in Zone 1 & get a double (3.7)
With SumIf you can count all men part time or full time within rows
D2
4000
I want to count all part time men within rows D2
4000 WHERE A2:A4000
= 1
Any suggestions??
Thanks
Clive
I have a table with a number of values.
Each person is assigned a unique attribute (identifier), zone (1 -
43), gender and employment (full or part time)
Pivot only gives 21 or 22
I want to count the following.
All full time men in Zone 1 & get a double (21.5)
All part time men in Zone 1 & get a double (3.7)
With SumIf you can count all men part time or full time within rows
D2

I want to count all part time men within rows D2

= 1
Any suggestions??
Thanks
Clive