If you have XL2007, use Sumifs. If not, use Sumproduct, as in:
=Sumproduct((Data!P1:P1000="On Time")*(Data!O1:O10000))

Adjust the range to suit. You can't use full columns.

Regards,
Fred

"NoodNutt" wrote in message
...
Hi everyone

I use the SumIF() usually to great effect, but this one has the grey
matter throbbing.

=SUMIF(Data!$P:P,"On Time",Data!O:O)

This returns the expected total if I wanted all the amounts in Column "O",
but in this case, I don't, I only need the sum of "O", if the figure in
"O" is 0.

I use SumProduct() which works great for counting the number of cells that
match my set conditions, but it does not sum the actual total value of
said cells within the required conditions.

Essentially, I am looking for something like:

=SUMIF(AND(Data!$P:P,"On Time",Data!O:O)Data!O:O0)

I need to identify and sum seperately, those totals above and below zero
for mapping specific data.

TIA
Mark.