Hello.
I have a table, in which I have a row of numeric value, and underneath it a row of text, and then again more pairs of rows as such, underneath.
I'm looking for a formula to sum all cells that have underneath them the letter 'a' (just as an example). (in the small example below, the answer will be 85).
I can do it only for one pair of rows using SUMIF, but I can't seem to find a way to do it for a big table, with many pairs of rows such as these.
I'd be very happy if anyone can help.
THANK you!
<colgroup><col width="72" span="6" style="width:54pt"> </colgroup><tbody>
</tbody>
I have a table, in which I have a row of numeric value, and underneath it a row of text, and then again more pairs of rows as such, underneath.
I'm looking for a formula to sum all cells that have underneath them the letter 'a' (just as an example). (in the small example below, the answer will be 85).
I can do it only for one pair of rows using SUMIF, but I can't seem to find a way to do it for a big table, with many pairs of rows such as these.
I'd be very happy if anyone can help.
THANK you!
54 | 8 | 65 | 54 | 32 | 2 |
d | a | r | f | d | a |
29 | 18 | 17 | 13 | 32 | 1 |
d | e | a | a | f | d |
20 | 15 | 16 | 18 | 13 | 11 |
a | f | v | b | e | w |
11 | 31 | 10 | 13 | 15 | 11 |
d | e | a | w | a | s |
<colgroup><col width="72" span="6" style="width:54pt"> </colgroup><tbody>
</tbody>