I have a single column of data. There are several occurences of the
text "PAX" and always there is a number in the cell below. Is there a
simple formula I can use to sum all these numbers up? Tried a sumif
but no luck.

e.g.

PAX
6

4

2

PAX
10

answer should be 16