count specific object form comma separated data.

suppose i have enter::
apple,ball,apple,apple in A1
apple,apple,apple,ball in A2
ball,ball,ball,apple in A3

Now i need total number of apple in entire column A.
please help me.

try

Formula:

Please Login or Register  to view this content.

where in C1 type your word, eg. apple
I don't know it will work on Google Sheet

Try

=SUMPRODUCT((LEN(A1:A3)-LEN(SUBSTITUTE(A1:A3,"apple",""))))/LEN("apple")

first split, then count

Great,, Thanks A Lot,, my problem is solved.

Thanks all my problem is solved.

If the basic problem is solved
- it's always a good practice to show respect to the person(s) who have helped you
- is a click on the Add Reputation first (left lower corner of the post of person(s) who helped you) and then
- mark the thread as SOLVED (top right corner over your first post - Thread Tools). This is important for all of us,
Thanks

Glad to help and thanks for the feedback

I need another help too can you help me?

If next problem is similar to your first post , ok, but if different - create new thread

its like same

it will be easy if you will provide me your gmail so that i can share you my google sheet then you will put formula there.

Save your work from Google Sheet to local file and....

with description

Attach a sample workbook. (Not a picture!)
Make sure there is just enough data to demonstrate your need. Include a BEFORE (original) sheet and an AFTER (required output) sheet in the workbook if needed to show the process you're trying to complete or automate.
Make sure your desired results are shown, mock them up manually if necessary. Remember, it should reflect original structure of your data.
Remember to desensitize the data.
Note:

• Please do not attach password protected workbooks/worksheets
• Please do not attach file(s) from exterior servers
• Please do not attach file(s) with enabled any Workbook Open/Autorun macros!

20 rows of data is enough (probably)

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
If link is not from FORUM server you have to wait until someone will want to watch the file from an external server.

Now i want to count delivered Product

hey can anyone help me to find number of only delivered product on this sheet?

try this

Formula:

Please Login or Register  to view this content.

can you please provide me that sheet in which you work??
it did not work here..

it return same answer as in "total number of required product" column,, product on second row are canceled,, i want to count product of only delivered row.

yeah i looked,, i found total delivered apple is 7, but it must be 4, because 3 are canceled...
and delivered ball are zero.. and cat is ...........................
what i need is,,
count product of that row which status is delivered....

I think my question was not fair so i m making you confuse.. in this attached sheet i have put there all detail and requirements.. please check that and send me that file after putting formula..

see attachment

you are really great,, thanks a lot for giving me this much time and helping me... really i m so happy to get this help....
again thanks a lot...