Skip to main content
AmigoFish

COUNTA function and Cell Arrays. Excel Magic Trick 1935

From excelisfun · · 1 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

Download Excel File: https://excelisfun.net/files/EMT1935.xlsx Mike excelisfun Girvin Excel books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=sr_ntt_srch_lnk_1&ccs_id=5f0ec91c-7a28-4a2b-9c87-04a7ee3159e6

Learn how to hard code Excel Arrays into cells and then use the COUNTA Function to count the items in the cell.

This video has subtitles or audio translation in thes 88 languages: Afrikaans, Albanian, Arabic, Armenian, Bangla, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Faroese, Fijian, Filipino, Finnish, French, French (France), Georgian, German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi, Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Sicilian, Sinhala, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Turkish, Ukrainian, Urdu, Vietnamese, Welsh, Zulu. Click language icon below video.

#excel #excel365 #excelisfun #mikegirvin #freeexcellessons #excelformulas #excelfunctions #COUNTA #CELLIST #CellArray #array #dynamicspilledarray #List

Back to excelisfun · Report a problem