I have 2 columns one with A,B,C's another with values I am looking for a function to put in where the star is to count the values in the test column that match the Alpha column. Many thanks
Test
A *
B
C
Alpha Test
A 3
A 34
A 4
A
A 6
A 7
A 8
A 9
A
A
A 3
B
B 34
B 12
B 35
B 7
B 8
B 9
B 0
C 0
C
C 9
C 6
C
C 5
Place in B2 and drag down to count the populated cells:
If you're looking of a sum of the cells that fit the criteria, try this in B2 and drag down:
Please Login or Register to view this content.
Will that work?Please Login or Register to view this content.
Hope this helps!
Last edited by mcmahobt; 12-18-2014 at 02:41 PM.
Spread the love, add to the Rep
"None of us are as smart as all of us."
An alternative...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you so much it worked
Cheers!... you're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks