Forum Discussion

Copper Contributor

Jul 18, 2022

Solved

Dynamic Definition of Tablename or Table Reference

Hi all, my Workbook contains n+1 Worksheets. The n Worksheets are data dumps such as Jan-22, Feb-22, Mar-22 and so on The +1 Worksheet represents an analysis / consolidation Worksheet. On ...

excel

Formulas and Functions

Riny_van_Eekelen
Jul 18, 2022
DSchizzle-Rock That would be with INDIRECT, like so:

Rsartori76

Brass Contributor

Jul 18, 2022

Use INDIRECT with COUNT
=COUNT(INDIRECT(B1&"[Deadline]"))

DSchizzle-Rock

Copper Contributor

Jul 18, 2022

Thanks Rsartori76. That was exactly what I needed. I am really impressed how exact you understood the problem (I wasn't sure if my description was understandable or not) and how quickly you responded to it!. Many, many thanks. Yours and Riny's responses were really the two things today worthwhile. Have a good time. Many thanks again and cheers! David