Formula in B3: SUMPRODUCT(COUNTIF(INDIRECT("'"&Tabs&"'!"&"B1:T1"),B$2))
Please help me to populate the counts for the Bravo Charlie Delta ie B4:G6
by making the right cell reference within " " for them .
This is basically to make the formula in B3 down to B4,B5 and B6 draggable but I cant figure it out since my countif range ie B1:T1 is within ""
Any suggestions for a work around
I have attached the workbook
Thanks
Alsan
Bookmarks