IF(INDIRECT ?

[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

 

[Bob Umlas]

Wherever you're specifying a range, surround it with INDIRECT("...")
=countif(A1:A100,"A")
becomes
=countif(INDIRECT("A1:A100"),"A")

 

[RagDyeR]

Copy from the formula bar, and exclude the equal sign.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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

 

[donh]

Many thanks

DonH