Hello,
I have 2 colums,
column A has 4 different names, column b has different items (see below)
How to I use a Countif statement to see how many TELE items belong to ben, how many internet's belong to bob etc.
Thanks in advance,
Ben
Ben
Ben
Adam
Ben
Ben
****
****
Ben
****
Ben
Bob
Bob
column B has all the different variables again,
so
Shop
Shop
TELE
TELE
Internet
Shop
Internet
Internet
Shop
Internet
Internet
TELE
TELE
benwall,
Attached is an example workbook based on the criteria described.
It contains three different ways of getting the results you're looking for.
The first is with a Countifs formula (Excel 2007 and higher only). In cell F4 and copied down:
Please Login or Register to view this content.
The second is with a Sumproduct formula (backwards compatible). In cell J4 and copied down:
Please Login or Register to view this content.
The third is with a pivot table.
You can use whichever you like best.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hello, sorry for the delay in reply. Thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks