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