How to use the countif funtion to count a codes that contain cells with muliple codes.
I have an excel spreadsheet with a column that contains muliple codes separated by ~. (IE. ~33~)
Column A CONTAINS A SERIES OF CODES USED FOR IDENTIFYING TYPES OF DATA
Column B contains the average days pending
Does anyone know what function I can use to count how many times "33" appears in column A? When I use =COUNTIF(A:A,"~33~"), it only counts 1. When I use =COUNTIF(A:A,"*33*"), it counts 4.
Re: How to use the countif funtion to count a codes that contain cells with muliple codes.
welcome to the forum. so it's supposed to return 2? try:
when you use tilde (~), it take the next symbol literally. that means if A1:A2 contains:
and i want to count those *A, i cannot use:
that will be anything before "A".
i must use it with a tilde to take the asterisk literally.
if it's possible 1 single cell contains 2 "~33~", and you want it as 2 counts, then:
the last portion can of course be divided by 4 instead of LEN("~33~"). just in case you need it for other characters
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled
| How to Get Quick & Good Answers
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By dtuck in forum Excel Programming / VBA / Macros
Last Post: 10-09-2013, 07:59 PM
By MDPLUS in forum Excel Programming / VBA / Macros
Last Post: 03-26-2013, 10:00 AM
By Security in forum Excel Formulas & Functions
Last Post: 09-14-2012, 10:37 AM
By chum in forum Excel General
Last Post: 11-28-2006, 01:08 PM
By Barbarosa in forum Excel General
Last Post: 02-07-2006, 12:20 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1