Explanation of "SelectedGroups"

[lemuel]

I found this formula on a excel sheet,

=IF(SelectedGroups="Project Nursery",COUNTA($A$5:A5),COUNTIF($A$5:A5,SelectedGroups))

can anyone explain about SelectedGroups?

[martindwilson]

selectedgroups looks like a named range but i cant see how its being used here,have a look in name manager

[lemuel]

it is being used in this thread. http://www.excelforum.com/excel-gene...-filtered.html

please explain further.

[lemuel]

it is being used in this thread. http://www.excelforum.com/excel-gene...-filtered.html
see DATA tab - at column Formula Help.

[martindwilson]

selectedgroups is a named range in that case it refers to a single cell ie =Data!$B$6
so the formula is really
=IF(Data!$B$6="Project Nursery",COUNTA($A$5:A5),COUNTIF($A$5:A5,Data!$B$6))

[lemuel]

thank you so much. That makes me really think for several hours. And I tried to google about SelectedGroups but can't find anwers. thank you.