I am trying to write a formula to tell me how many times i have an occurance of a value between 15 and 45.

i.e i have columns C6:J17 if a value of 16 - 45 goes into any of these columns more than once i would like a value of 1 to appear in B28 each time, but i don't want to see the value appear if it is below 15 or above 45, I have tried many variations of IF AND COUNTIF functions but i just can't get it to work,

Please Help

Hopefully your using 2007, because then you can use an =COUNTIFS() function, notice the s at the end. =COUNTIFS(C6:J17,">15",C6:J17,"<45")

MIKE

Ask Your Question

Weekly Poll