countifs with multiple criteria in the same cell

[karin23]

I have data in column W that has multiple answers to a question. Example (A, C, or A, H, or B, D,). I'd like to count all the As with a date equal to or prior to 10/1/17. I tried the formula below and know that I'm missing something but just not sure.

=COUNTIFS(data!Z2:Z10681,"<171002",data!W2:W10681,"A,")

 

[Peter_SSs]

Assuming all the answers consist of a single letter (ie not AA, AC etc) then try

=COUNTIFS(data!Z2:Z10681,"<171002",data!W2:W10681,"*A*")

 

[karin23]

Thank you so much. That was it.

Assuming all the answers consist of a single letter (ie not AA, AC etc) then try

=COUNTIFS(data!Z2:Z10681,"<171002",data!W2:W10681,"*A*")

 

[Peter_SSs]

Thank you so much. That was it.

No problem, glad to help.
BTW, welcome to the MrExcel board!