Extract a specific word from cells and count

Hello,



I want to find the formula in Excel 2003 to be able to extract a specific word from a cell and count the number of instances this word come up and provide the sum of times of this word being listed.

For example: I want to count the number of times the word 'SAP' or 'sap' appears and the following:

sap a ss
sap iuoa
sap
sap tey
hello sap
sap works

-----------------------------------------

The result should give me '6' in a cell.