Hi,
Two questions:
1.
I have a formula which is in quite a few cells. I want to change a specific
text can I do this en mass, or do I have to do each on manually.
e.g.
=SUMPRODUCT(--(B7:B173=B178),--(G7:G173="P"))/D178*100
I want to change the "P" to search for any entry in a cell in the relevant
columns.

2.
What do I replace the "P" with to be able to search for any entry in the
relveant column?

Thanks in advance