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.