Hi,
I'd be immensely grateful if you could help me with the following conundrum.
So I have this table in excel:
Name |
Sum |
a |
200 |
b |
100 |
|
|
a |
100 |
|
|
a |
250 |
b |
150 |
|
|
a |
100 |
|
|
a |
300 |
|
|
a |
150 |
b |
50 |
|
|
a |
350 |
b |
200 |
I want to sum the value of each cell opposite to "a", but only if it is not followed by a cell "b" (in bold and underlined).
In this example I should get 500.
Or vice versa, only sum the cells opposite to "a", which are followed by a "b".
Is there any (more or less simple) way it could be done?
Thank you very much in advance!