TB's Code Library
If it ain't tight, it ain't right!
Search
Thursday, March 13, 2008
Excel Formula to count word instances in a column based on 2 different criteria
=SUMPRODUCT(('Raw Data Tab'!$K$2:$K$15=$A3)*('Raw Data Tab'!$L$2:$L$15=I$1))
Newer Post
Older Post
Home