AnnasBananas
New Member
- Joined
- Sep 3, 2020
- Messages
- 5
- Office Version
- 2013
- Platform
- Windows
I think I've jumped into the part of Excel where I can't swim. Thanks in advance for the group's help!!
I'm counting multiple criteria: is it "completed", with this person "cell location", and site includes these letters at the beginning "
=COUNTIFS($B40:$B1033,"Completed",$F40:$F1033,W4,$D40:$D1033,{"PT*";"CF*";"IV*";"DS*";"SR*"})
I have reviewed the data and discovered that it's not counting any of my "CF*" data. Any ideas why it would leave that out of the count?
I'm counting multiple criteria: is it "completed", with this person "cell location", and site includes these letters at the beginning "
=COUNTIFS($B40:$B1033,"Completed",$F40:$F1033,W4,$D40:$D1033,{"PT*";"CF*";"IV*";"DS*";"SR*"})
I have reviewed the data and discovered that it's not counting any of my "CF*" data. Any ideas why it would leave that out of the count?