in it vs up shit creek

in it

prep
  • In trouble. 

  • Taking part in something, such as a lottery. 

  • Having an expected payout or reward. 

  • Getting on successfully, especially in a game. 

up shit creek

prep
  • In trouble; in a difficult situation. 

How often have the words in it and up shit creek occurred in a corpus of books? (source: Google Ngram Viewer )