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, "A1"
and "A5" via ADDRESS function). How can I convert it to a range with a
function? Using INDIRECT and concatenate them with ":" in it as parameter?

Thanks in advance.
---
Tetsuya

=COUNTIF(A1:A5,TRUE)0

=SUM(INDIRECT(ADDRESS(1,1)&":"&ADDRESS(5,1)))

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Tetsuya Oguma" wrote in message
...
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,
"A1"
and "A5" via ADDRESS function). How can I convert it to a range with a
function? Using INDIRECT and concatenate them with ":" in it as parameter?

Thanks in advance.
---
Tetsuya