Question: My website cannot go live!

```

The following is my web server setup.  

1.  Rogers modem – Hitron CODA-4582  

2.  Port Forwarding
Application Name    Public      Private     Protocol    Local IP Address
HTTP                80 – 80     800 – 800   TCP         192.168.0.201
HTTPS               443 – 443   883 – 883   TCP         192.168.0.201  

3.  Operating System - ubuntu 16.0.4
Apache2 Sever /etc/apache2.conf file.
I modified two things.
a.  Uncommented the line ServerRoot “/etc/apache2”
b.  Appended one line at the end of the file: ServerName my_rogers_IP_address.
I executed a command: sudo app info “Apache Full”
The output is 
Profile: Apache Full
Title: Web Server (HTTP,HTTPS)
Description: Apache v2 is the next generation of the omnipresent Apache web
server.

Ports:
  80,443/tcp

Then, I executed another command: sudo ufw allow in “Apache Full”
```

I thought I have done what I needed to do. So, I opened up the browser for testing. It only works for 127.0.0.1 or localhost. It won’t work if I enter <http://my_rogers_IP_address>.
Can someone give me a pointer?
Thank you in advance!

Answer: 
You can use `Match` to locate the column, and `Index` to return that column, and pass it to `Countif`

```
=COUNTIF(INDEX(1:1048576,,MATCH("Business",1:1,0)),"test")

```
You can use `INDIRECT` to convert a string to a Range. So, `=COUNTIF(INDIRECT("E:E"),"test")` evaluates to `=COUNTIF(E:E,"test")`:

```
=COUNTIF(INDIRECT(SUBSTITUTE(ADDRESS(1,MATCH("Business",A:E,0),4),"1","")&":"&SUBSTITUTE(ADDRESS(1,MATCH("Business",A:E,0),4),"1","")),"test")

```