here is what i am looking to do.

for the cell range of eg. A1:A7

I would like to take each cell, and if it is equal to or less then 0 to ignore it, then for all the cells that are More then 5. I would like to add all that up and take the value from each cell and subtract 8. so that it only gives me the total value of what is over 5. I hope you understand what I am trying to get at.

let me try to explain it this way

if cell A1=0 A2=7 A3=8 A4=6 A5=9 A6=6 A7=0 my total that I want to see is 11 not 36.

thanks in advance for you assistance.