exclude minus figures?

Please Login or Register  to view this content.

if the answer to the above = a minus number then 0

Please Login or Register  to view this content.

how do i get the above to exclude minus numbers

For the first try

Please Login or Register  to view this content.

For the second I presume you mean that you don't want to sum any negative numbers in TL!$D$2:$D$5000 even when the other condition are met, try

=SUMPRODUCT((TL!$F$2:$F$5000=TOTALS!$A2)*( TL!$G$2:$G$5000=B$1)*(TL!$D$2:$D$5000>0),TL!$D$2:$D$5000)

this counts the number of values above 0 instead summing up the figures and excluding minuses

The SUMPRODUCT formula should sum all values in TL!$D$2:$D$5000

where 1) that value is greater than zero, 2) column G for the corresponding row is equal to B1 and 3) column F for the corresponding row is equal to Totals!A2.

It shouldn't just give you a count, what result did you get, what did you expect?

..im not sure .. i need to look into this will get back if i need further help