The array formula helped me parse everything which is great but now I thought I'd be able to perform the auto sum. It doesn't add correctly though.
Now my columns look like this
![]()
COLUMN A COLUMN B COLUMN C 10.172.161.0/24 20.0% (8/40) (8/40) 10.172.162.0/24 5.0% (10/200) (10/200) 10.172.163.0/24 0.0% (0/0) (0/0) 10.172.164.0/23 58.0% (259/446) (259/446)
Bookmarks