Hello I am looking for a vlookup formula that will count the text values in column B based on the value in column A. Thanks.
Philadelphia 0 (Return value should be 10)
Column A Column B
Philadelphia AAAA
Philadelphia BBBB
Philadelphia AAAA
Philadelphia BBBB
Philadelphia AAAA
Philadelphia BBBB
Philadelphia AAAA
Philadelphia BBBB
Philadelphia AAAA
Philadelphia BBBB
Last edited by ensmith; 07-16-2012 at 09:45 PM.
You need to be more specific about the criteria in column-A.
VLOOKUP is not a counting function.
See Excel Help on COUNTIF and COUNTIFS.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
The criteria in column A is "Philadelphia". I just simply want a formula that will count the values in Column B that are associated with the one value in Column A which is Philadelphia.
something like this??
=COUNTIFS(B1:B10,"<>"&"",A1:A10,"="&A1)
even if there is "philadelphia" if column B is blank it will not count.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thanks that works for me.
welcome.
=COUNTIFS(A1:A10,"Philadelphia",B1:B10,"<>")
No need for the ampersand and cell A1 may not contain Philadelphia or whatever text criteria you have.
If you want the formula to be flexible, then rather than hardcode "Philadelphia", use an input cell and reference this cell in the argument instead of the text string.
thanks for your help that works for me too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks