in Excel 2010, how can i use countifS to count the number of times column 'B' has initials "EG" AND column 'D' has the word "yes". The problem is that column D has the word "yes" along with other characters such as "TR/yes".
my formula is currently =COUNTIFS(B10:B3000,I1,D10:D3000,"yes")
column B has many initials and column D has any number of different characters with sometimes the word yes in column D.
not working
kindest thanks,
Eddie
my formula is currently =COUNTIFS(B10:B3000,I1,D10:D3000,"yes")
column B has many initials and column D has any number of different characters with sometimes the word yes in column D.
not working
kindest thanks,
Eddie