help need formula to count number with word

hi guys im new here and a newbie on excel looking forward to learn more from you guys.

what i want to happen is, i want to sum the value for a certain cells with number and words on it, for example

i want to sum the "1 tablets" "2 tablets"

thanks in advance

Hi,

Can you post a sample template of your workbook in excel format?

http://www.excelforum.com/members/da...ch-a-file.html

attached is the sample excel im working

Hi,

Try the following formula in G4:

=SUMIF(Table1[medicine],[@medicine],Table1[COUNT])

See the file attached.

GREAT!! Many thanks cbatrody!! this gives me a big smile on my face!

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.