Hi all,
I am trying to get a count of all people who match two variables.
First is their work type being level 1, 2 or 3) and finally whether they are full time or part time.
This is the current formula I have and it was working, but now its not.
=SUM(IF($F$9:$F$1946=$U2,IF($G$9:$G$1946=W$1,1,0),0))
Column F is made up of Type (1,2 or 3)
Column G is made up of hours (FT or PT)
W1 = FT, UT = 1 (for this example)
Currently the error I am getting is #value
Thanks for having a look
I am trying to get a count of all people who match two variables.
First is their work type being level 1, 2 or 3) and finally whether they are full time or part time.
This is the current formula I have and it was working, but now its not.
=SUM(IF($F$9:$F$1946=$U2,IF($G$9:$G$1946=W$1,1,0),0))
Column F is made up of Type (1,2 or 3)
Column G is made up of hours (FT or PT)
W1 = FT, UT = 1 (for this example)
Currently the error I am getting is #value
Thanks for having a look