I have 5 tabs of data, an example of one tab of data is like this, each tab corresponds to a day.

(A1)Red (B1) Blue (C1) Yellow (d1) Total

(A2) 5 (B2) 10 (C2) 7 (d2) 22

(A3) 5 (B3) -10 (C3) -3 (D3) -8

I have a summary tab which i would like to do the sum if statement

I want to summarise the data but the criteria is if the Total cell is bigger then 0.

so i want to sum all the reds (including all of the tabs) only if the total is bigger then 0 for the line of data.

So for Reds on A2 i want to sum all the reds up but if only on that day the total is bigger then 0.

Hope that makes sense....

thanks