Hi all,
This is quite complicated but I'll try to make it as simple as I can.
I have a spreadsheet og IP address info and I would like to count on multiple conditions, I've already managed this in other parts of my spreadsheet but when I try to use the below I don't get any results, I've been through having the "N/A" and "Value" problems but now I get a "0" value:
=SUMPRODUCT(Subnets!$G$2:$G$756=A35)*(Subnets!$E$2:$E$756="")*(LEFT(Subnets!$F$2:$F$756,8)="10.236.8")
I'll try and explain what I'm trying to do, My IP list contains a List of Subnets with Names, Subnet address and Subnet mask. What I want to do is count
1.how many times a particular size subnet is used (i.e.255.255.255.240, this list starts at "A35"
2.If that Subnet has no Name
2.and the subnet address starts with "10.236.8"
After entering the above formulea I go into the range that is been queried and delete some sunbet names but the results don't appear in my spreadsheet.
Anyone got any ideas?
This is quite complicated but I'll try to make it as simple as I can.
I have a spreadsheet og IP address info and I would like to count on multiple conditions, I've already managed this in other parts of my spreadsheet but when I try to use the below I don't get any results, I've been through having the "N/A" and "Value" problems but now I get a "0" value:
=SUMPRODUCT(Subnets!$G$2:$G$756=A35)*(Subnets!$E$2:$E$756="")*(LEFT(Subnets!$F$2:$F$756,8)="10.236.8")
I'll try and explain what I'm trying to do, My IP list contains a List of Subnets with Names, Subnet address and Subnet mask. What I want to do is count
1.how many times a particular size subnet is used (i.e.255.255.255.240, this list starts at "A35"
2.If that Subnet has no Name
2.and the subnet address starts with "10.236.8"
After entering the above formulea I go into the range that is been queried and delete some sunbet names but the results don't appear in my spreadsheet.
Anyone got any ideas?