Advanced count function
Lets say my data looks like this:
A B
5 Travis
4 Travis
3 Nick
2 Travis
1 Don
9 Mike
How do I make a count function that looks at that and the logic is:
If A is less than 4 and B equals Travis
And just to clearify that I understand if I get an answer, how would I do:
If A is greater than 2 and A less than 15 and B equals Travis
To verify, I want the number returned of how many results there are.
Thank you for looking, and for your help/time.
|