Bright01
asked on
Simple Formula Fix - Countif and "and" statements
EE Pros,
I have a simple formula that I cannot make work. I'm trying to count the selections that meet two criteria. I've tried to make this selection by using a Countif statement and an "and" statement. But it doesn't select on that criteria.
=COUNTIF(J11:J115,"Sales Rep")*(AND(COUNTIF(B11:B11 5,"Yes")))
Any help would be appreciated.
B.
I have a simple formula that I cannot make work. I'm trying to count the selections that meet two criteria. I've tried to make this selection by using a Countif statement and an "and" statement. But it doesn't select on that criteria.
=COUNTIF(J11:J115,"Sales Rep")*(AND(COUNTIF(B11:B11
Any help would be appreciated.
B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Zings....late by whole 90Secs.
Seen your post after I had posted as browser not auto refresh ... ;)
=COUNTIFS(J11:J115,"Sales Rep",B11:B115,"Yes")
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
oh, i should have refreshed the page
Same thing here.
ASKER
Asking another question now on counting Filtered fields.
Thank you,,,, great teamwork!
b.
Thank you,,,, great teamwork!
b.
I guess Saurabh deserved all points.