software

Hi all,

A simple question.

1. I want to check if any cell in A1:A5 shows TRUE. What is a formula that
returns TRUE for that and FALSE if every cell in the range is FALSE?

2. I derive the starting and ending cells for the range in text (.e.g, quot;A1quot;
and quot;A5quot; via ADDRESS function). How can I convert it to a range with a
function? Using INDIRECT and concatenate them with quot;:quot; in it as parameter?

Thanks in advance.
---
Tetsuya

=COUNTIF(A1:A5,TRUE)gt;0

=SUM(INDIRECT(ADDRESS(1,1)amp;quot;:quot;amp;ADDRESS(5,1)))

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Tetsuya Ogumaquot; gt; wrote in message
...
gt; Hi all,
gt;
gt; A simple question.
gt;
gt; 1. I want to check if any cell in A1:A5 shows TRUE. What is a formula that
gt; returns TRUE for that and FALSE if every cell in the range is FALSE?
gt;
gt; 2. I derive the starting and ending cells for the range in text (.e.g,
gt; quot;A1quot;
gt; and quot;A5quot; via ADDRESS function). How can I convert it to a range with a
gt; function? Using INDIRECT and concatenate them with quot;:quot; in it as parameter?
gt;
gt; Thanks in advance.
gt; ---
gt; Tetsuya