How can I check if any of the entires is True in a range?

[Tetsuya Oguma]

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.

 

[Peo Sjoblom]

=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