Counting multiple data in cell more than once

Alaska1 · #1 02-27-2015, 06:14 AM

The data is in a Table because I will be making updates to this document. If I use the code below will that work.

=SUMPRODUCT(--(LEN(Table1)-LEN(SUBSTITUTE(UPPER(Table1);"VIDEO";"")))/LEN("Video"))

I will need to change it for the other categories in that field

=SUMPRODUCT(--(LEN(Table1)-LEN(SUBSTITUTE(UPPER(Table1);"BTS";"")))/LEN("BTS"))

Thank you for your help

Alaska1 · #2 03-01-2015, 04:27 PM

Thank you for your help. I adjusted the formula using sumproduct and it worked.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extracting data from a cell with multiple lines of text	MMT	Excel	9	02-12-2015 09:18 PM
Looking for VBA or Macro Counting a specific value occuring in single, random, changing cell?	blackjack	Excel Programming	1	09-11-2014 11:27 PM
Multiple data in one cell?	New Daddy	Excel	4	09-06-2013 02:50 AM
Counting cells with multiple complex criteria	TishyMouse	Excel	12	12-06-2012 05:05 AM
various data needs counting	apples	Excel	2	09-16-2012 04:52 AM