countif, but only using partial cell contents in the reference array

J

jaredh

=MID(a1000,FIND("{",a1000,1)+1,8)
This formula returns the portion of the cell that is important to me


However, if I want to match a portion of the reference cell array t
the portion of the criteria cell, how do i do that?

=countif(a1:a100, MID(a1000,FIND("{",a1000,1)+1,8), 0)

I don't understand how to change the a1:a100 to to only lookat th
MID(a1,FIND("{",a1,1)+1,8) portion of it.....


much thanks,

jare
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countif, but only using partial cell contents in the reference array 2
countif, but only using partial cell contents in the reference array 1
How to apply countif? 3
showing cell locations per answer from Ron Coddere - stuck! 1
countif, but only using partial cell contents in the reference array 1
Return value using partial value of a cell. 2
COUNTIF conundrum 5
countif using cell references in criteria 2

Top