COUNT /COUNTIF for Multiple Column Defined Dynamic Named Range

[Tinä]

Hi,

Would like to use Dynamic Named Range "RESULTS" in Formula. The Dynami
Named Range "RESULTS" spans 30 COLUMNS and many ROWS.

Need help with Formula to COUNT specified criteria in each separat
COLUMN of the Defined Dynamic Named Range "RESULTS". Looking for on
Formula that can be adapted with an OFFSET / INDEX to work on the othe
COLUMNS.

Example Results required from Formula:
COLUMN 1 in Dynamic Named Range "RESULTS" - COUNT instances of numbe
75
COLUMN 2 in Dynamic Named Range "RESULTS" - COUNT instances of numbe
75
COLUMN 30 in Dynamic Named Range "RESULTS" - COUNT instances of numbe
75

Thanks
Tin

 

[Myrna Larson]

Look at Help for INDEX for more information on how to return an entire column.

=COUNTIF(INDEX(Results,0,1),75)
=COUNTIF(INDEX(Results,0,2),75)
=COUNTIF(INDEX(Results,0,30),75)