LinkBack URL
About LinkBacks
joshkvt 
Assuming that FB will always be first you should be able to do something like:
=countifs(A1:A10,"*FB*Milton*",B1:B10,"PHOTO")
Edit, in any order, you could use:
=sum(countifs(A1:A10,{"*FB*Milton*","*Milton*FB*"},B1:B10,"PHOTO"))
Assuming that FB will always be first you should be able to do something like:
=countifs(A1:A10,"*FB*Milton*",B1:B10,"PHOTO")
Edit, in any order, you could use:
=sum(countifs(A1:A10,{"*FB*Milton*","*Milton*FB*"},B1:B10,"PHOTO"))
That seems to do the trick. Thanks very much for the prompt help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks