Shakeable_Drip
Board Regular
- Joined
- May 30, 2023
- Messages
- 50
- Office Version
- 365
- Platform
- Windows
can sumifs with MID-INDEX-MATCH be used to sum target text strings in a column? hopefully without a helper column.
unfortunately, mini table doesn't appear to be working for me, anyways. this adds to a project im working on over here.
the sequence of arguments or criteria is getting murky, maybe there is a better way?
unfortunately, mini table doesn't appear to be working for me, anyways. this adds to a project im working on over here.
the sequence of arguments or criteria is getting murky, maybe there is a better way?
Excel Formula:
=MID(INDEX(A:A,MATCH("*"&" <Repeat> "&"*",A:A,0)),SEARCH(">",INDEX(A:A,MATCH("*"&" <Repeat> "&"*",A:A,0)))+1,SEARCH("</",INDEX(A:A,MATCH("*"&" <Repeat> "&"*",A:A,0)))-SEARCH(">",INDEX(A:A,MATCH("*"&" <Repeat> "&"*",A:A,0)))-1)*1
DATA SET | MID FOR "REPEAT" | SUM OF ALL REPEAT |
<Repeat> 16 </Repeat> | 16 | 32 |
<Time> 145383 </Time> | 0 | |
<Repeat> 16 </Repeat> | 16 |