Re-post Didn't appear first time

[donh]

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

 

[Guest]

donh,
CountIF is looking in cells A1:A100 for A.
If you want to count the values greater than 0 try:
=CountIF(A1:A100,">0")
HTH