Some - Affirmative sentences , plural countable or sing uncountable ( alguno, algo de)
ex. I need some peas He wants some water
Some - Interrogative. In offers, requests
ex. Would you like some chips?
Any- negative and interrogative plural count, sing uncountab ( alguno , ninguno)
Ex. I don´t have any meat Did he buy any potatoes?
Any - whichever ,(-Cualquiera). in this case you can use it in many cases ( ,affir countable uncountable) Ex Any meat will be delicious. I can meet any friend of yours
I guess there must be more things to say about them, but it is a good start, don´t you think?
Hope it helps