Hi hope you can help!

I have a number of copies/versions of the same spreadsheet (layout)
which I now have to do a column content count on ie
=countif(A1:A100,"A")

but I only need to count this if another total in the same column is
greater than 0 zero

I can do this with an IF statement, but of course when I copy the
formula into the other workbooks the original sheet reference
remains.  I thought I might be able to use INDIRECT() but can't see if
this can be tied to an IF()

As always any help or other suggestions would be welcome.

Regards

DonH