I guess if and or countif formula help

December 7, 2010 at 09:00:55
Specs: Windows XP
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

See More: I guess if and or countif formula help

Report •

December 7, 2010 at 18:01:03
Hopefully your using 2007, because then you can use an =COUNTIFS() function, notice the s at the end.




Report •
Related Solutions

Ask Question