anglais428
Well-known Member
- Joined
- Nov 23, 2009
- Messages
- 634
- Office Version
- 2016
- Platform
- Windows
I am providing a sample table below:
<tbody>
</tbody>
I can do a Countif to get the number of A's or B's. Or something like =SUM(COUNTIF($A$2:$A$7,{"A","B"})) to get the number of As and Bs.
I would like to refer to the part {"A","B"} as a cell reference, rather than have to manually type this.
Note, this is a condensed version for illustration only (so sumproduct would not be the best result for me).
Thanks
A |
B |
A |
A |
B |
<tbody>
</tbody>
I can do a Countif to get the number of A's or B's. Or something like =SUM(COUNTIF($A$2:$A$7,{"A","B"})) to get the number of As and Bs.
I would like to refer to the part {"A","B"} as a cell reference, rather than have to manually type this.
Note, this is a condensed version for illustration only (so sumproduct would not be the best result for me).
Thanks