One way:

=SUMIF(A1:A10,"Pax",A2:A11)

Notice that the two ranges have the same number of cells, but the second range
is offset by one row.

ajnmx wrote:

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

--

Dave Peterson