Hopefully someone can help me with the problem I'm having. I have looked into as many count functions I can think of and dived into array functions and i feel that I am 75% to figuring this out. So to set the table for you this is what I got:
T-Shirt Size
Smith L,L Jones L Cox L,L,L Russ XL,L L XL XXL
So I have figured out the formula to count the "L" in this chart, however the problem I am having is no mater what function or array function I use, when I set it to count the "L" it includes the "L" in XL too and I do not want that. What function can I use where in the cell next to L at the bottom it will count up all the "L" only and reflect 7 Large shirts needed instead of 8 because it reads the L in XL. Does that make sense? thanks for any help.
Bookmarks