montyfern
Board Regular
- Joined
- Oct 12, 2017
- Messages
- 65
Good Day All!
Close but no cigar? VBA? Pivots? I have a list with labels where I need to count every instance of ^ or exponents that's embedded in individual cells. It will constantly change. I tried the following formulas:
<tbody>
</tbody>
For example:
<tbody>
</tbody>
Close but no cigar? VBA? Pivots? I have a list with labels where I need to count every instance of ^ or exponents that's embedded in individual cells. It will constantly change. I tried the following formulas:
=COUNTIFS(A2:D2,"*^*") =SUMIF(A2:D2,"*^*",$E$2:$E$11) =MATCH("^",A2:D11,0)-MATCH("^",A2:D11,0)-3 which gives the dreaded N/A error. |
<tbody>
</tbody>
For example:
SO | Support | Type of Meeting | Mechanic | Count | Total |
Reginald Smith^2 | B. Lawford ^ | F2F | R13 | 2 | |
Patricia Jones ^1 | P. Redland | Tele. | U19 | 1 | 2 |
Sidney Poitier ^2 | P. Newton | F2F | R02 | 1 | 2 |
Elizabeth Taylor ^2 | E. Hernandez | Tele. | U19 | 1 | 2 |
Paul Newman ^2 | S. DeLorean | Tele. | R13 | 1 | 2 |
Robert Redford | T. Manilow | F2F | U19 | ||
Cecily Tyson ^2 | J. Johnson | F2F | U19 | 1 | 2 |
Robert Redford | W. Washington | Tele. | R02 | ||
Paul Newman ^2 | K. Kowalski | F2F | U19 ^ | 2 | 2 |
Barry Jones ^3 | S. DeLorean ^ | Tele. ^ | R13 | 3 | |
Aggregate Sum | 12 | 12 | |||
Then, I have simple sums which both denote 12 as you can see. Thanks so much. |
<tbody>
</tbody>