% Formula help
 

Hi,
What formula would I use if I wanted a cell to report a percentage.
The percentage I would require is for the cell to search a column e.g.
"B6:B172", look for a particular term e.g. "G" and then look across the row
to a particular cell e.g. "G6" to see if anything has been inputted.

Thanks in advance

Jason