Hello everyone,

Wondering how can I count similar words if I have the following data:

Column A:
dropbox
icloud, googledrive
google drive
Microsoft OneDrive
Drop box
Google
Google Docs and OnlyOffice
google drive
google
dropbox, google drive
Dropbox, OneDrive
Google docs, dropbox
Calibre Content Server Amazon Photo Prime DropBox
Google Drive, MEGA
Google drive, yahoo mail and earlier dropbox.
I use the apple cloud and google's cloud service.
When I do, usually DropBox
Dropbox, icloud

And I would like to have the output like this:
Column B Column C
dropbox 8
icloud 2
google 10 --- should count all word occurrences like: googledrive, google drive, google, google docs
docs 1
etc..

I just need to count how many words in this list to understand the stats on each of them. I would appreciate your tips on how to approach this with a formula or a macros.

Thanks in advance!