I am attempting to use a COUNTIFS formula but I need my 2nd set of criteria to include an entire list of cells. Here is the formula that I am currently attempting:
=COUNTIFS($b$2:$b$40,a2,$d$2:$d$40,$c$2:$c$10)
This only works the way I want it to if the 2nd criteria is in the same row as the 1st criteria. I need it to add to the count if my criteria shows up anywhere in the list I have made from c2 to c10.
Thanks for any help you can offer.
Bookmarks