IF(INDIRECT ?

  • Thread starter Thread starter donh
  • Start date Start date
D

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
 
Wherever you're specifying a range, surround it with INDIRECT("...")
=countif(A1:A100,"A")
becomes
=countif(INDIRECT("A1:A100"),"A")
 
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
 
Back
Top