I have found an oddity in my countifs program where it is counting the value it is suppose to be greater than.
The range ("I7") will include 219A and 219B when it calculates a value.
The range ("I17") doesn't include the 219A/B values and counts from 218A/218B and lower.
Thats is what I want, but originally I had ">218*" which I thought would only include 219 and up, but it also included 218. Does anyone know why the > than symbol is including "= to" and why the < than doesn't include "= to"...???
Macklin
Code:
Worksheets("sheet1").Range("I7").Value = [countifs(sheet1!F2:F10000,"="&sheet1!R1,sheet1!P2:P10000,">219*")]
Worksheets("sheet1").Range("I17").Value = [countifs(sheet1!F2:F10000,"="&sheet1!R1,sheet1!P2:P10000,"<219*")]The range ("I7") will include 219A and 219B when it calculates a value.
The range ("I17") doesn't include the 219A/B values and counts from 218A/218B and lower.
Thats is what I want, but originally I had ">218*" which I thought would only include 219 and up, but it also included 218. Does anyone know why the > than symbol is including "= to" and why the < than doesn't include "= to"...???
Macklin
