I've seen a few examples of similar questions, but none seem to me to be a fit. I would like to summarize the number of scores (# of 1's, # of 2's, etc) given to a vendor when that vendor is chosen. Any help, please. Attached is example.
Thanks,
Tony
Hlookup & Countif Question.xlsx
Use
=COUNTIF(INDEX(Data!$B$4:$F$9,,MATCH($B$3,Data!$B$3:$F$3,0)),3)
Where B3 refers to the vendor name
Change highlighted result for varied results. Alternatively you could also referwnce it to a cell
Life's a spreadsheet, Excel!
Say thanks, Click *
With an pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Ace_XL, thanks for the help. That worked perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks