Counting multiple data in cell more than once

		Microsoft Office Forums > Microsoft Excel > Excel
Counting multiple data in cell more than once

FAQ

Thread Tools

Display Modes

02-27-2015, 06:14 AM

Alaska1

Windows 7 64bit Counting multiple data in cell more than once

Office 2007

Competent Performer

Join Date: Nov 2011

Posts: 110

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:18 PM.