WS attached
I need a formula to count how many items in B2:B8 & C2:C8, then put the appropriate count under the coinciding rows where the same item is labeled.
Example: B6 & C6 both have the word “Apple” so in D6 the number 2 would populate.
WS attached
I need a formula to count how many items in B2:B8 & C2:C8, then put the appropriate count under the coinciding rows where the same item is labeled.
Example: B6 & C6 both have the word “Apple” so in D6 the number 2 would populate.
Enter this formula in D2:
=COUNTIFS($B2:$C2,D$1)
Then copy it down and across. (if you don't want the 0's showing, you can wrap an if statement around it)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks