S
Sam via OfficeKB.com
Hi All,
I'm using the Formula below to give me a static count of numeric values that
fall within a specified range; say 50-75 inclusive. These ranges are housed
in cell X$1. The Named Range "Data" is a dynamic 9 column range spanning many
rows. Named Range "Data" is defined as
=OFFSET(Sheet1!$H$15,0,0,COUNT(Sheet1!$H:$H),9)
Static Count:
=COUNTIF(Data,">="&LEFT(X$1,2))-COUNTIF(Data,">"&RIGHT(X$1,2))
Based on the above can anyone provide a Formula that provides a Dynamic Count
when "Data" is filtered.
Thanks
Sam
I'm using the Formula below to give me a static count of numeric values that
fall within a specified range; say 50-75 inclusive. These ranges are housed
in cell X$1. The Named Range "Data" is a dynamic 9 column range spanning many
rows. Named Range "Data" is defined as
=OFFSET(Sheet1!$H$15,0,0,COUNT(Sheet1!$H:$H),9)
Static Count:
=COUNTIF(Data,">="&LEFT(X$1,2))-COUNTIF(Data,">"&RIGHT(X$1,2))
Based on the above can anyone provide a Formula that provides a Dynamic Count
when "Data" is filtered.
Thanks
Sam