T
Tim Kuhn
Hello
I have a question regarding counting values and cross referencing to a range
on another worksheet.
The values are IP Addresses (10.64.xxx), so I guess my first question is
whether it is possible to assign them to particular ranges.
I have two worksheets, one being the source file, with column E containing
IP addresses. The other worksheet contains IP address ranges in columns
A&B.
I am basically looking to do a count of the source file addresses and
allocate by range.
I'm currently using the COUNTIF formula below but have not had any luck:
=COUNTIF(source!$E$2:$E$9686, AND(">="&A3,"<="&B3))
Any suggestions are appreciated
Regards
Tim Kuhn
I have a question regarding counting values and cross referencing to a range
on another worksheet.
The values are IP Addresses (10.64.xxx), so I guess my first question is
whether it is possible to assign them to particular ranges.
I have two worksheets, one being the source file, with column E containing
IP addresses. The other worksheet contains IP address ranges in columns
A&B.
I am basically looking to do a count of the source file addresses and
allocate by range.
I'm currently using the COUNTIF formula below but have not had any luck:
=COUNTIF(source!$E$2:$E$9686, AND(">="&A3,"<="&B3))
Any suggestions are appreciated
Regards
Tim Kuhn