Jerry Cook
Fairfax, VA, USA
Member
Members
Forum Posts: 7
Member Since:
October 9, 2014
October 9, 2014
Offline
I have a dynamic list, and need to count the items in a given column identified by a MATCH operation.
How do I convert (for example) COUNTA(G:G) to COUNTA(the entire column #7 returned by the MATCH).
I don't want to switch to RC format, but rather deal with it via formula.
I am so sure there is a simple solution, but for the life of me, can't find a single example.
Stay safe out there!
Jerry
Catalin Bombea
Iasi, Romania
Member
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
Forum Posts: 1909
Member Since:
November 8, 2013
November 8, 2013
Offline
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Riny van Eekelen, Dirk Veeken, Mallika Asireddy
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1909
SunnyKow: 1432
Anders Sehlstedt: 899
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 279
lea cohen: 245
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Mallika Asireddy
Sheila Sanders
Francine Walshe
Sean Ladlow
Jorge Chicas
mahmoud salem
Irvine Choolo
Deon Bouwer
Amgad Squires
jim bo
Forum Stats:
Groups: 3
Forums: 24
Topics: 6836
Posts: 29985
Member Stats:
Guest Posters: 49
Members: 33569
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —