Thread: [Solved] Counting multiple data in cell more than once
View Single Post
 
Old 02-27-2015, 06:14 AM
Alaska1 Alaska1 is offline Windows 7 64bit Office 2007
Competent Performer
  
Join Date: Nov 2011
Posts: 110
Alaska1 is on a distinguished road
Default
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
Reply With Quote