Concatenation issue

[Belair58]

Hello,

I have a macro that's generating subtotals, cell O16's formula is =SUBTOTAL(3,O4:O15)

I've isolated the range down by using LEFT and RIGHT in Cell U16 O4:O15

I now need to have cell V16's formula to be =ROUND(COUNTIF(U16,"LATE")/COUNTA(U16)*100,2)

I've tried using &

=ROUND(COUNTIF(&U16&,"LATE")/COUNTA(&U16&)*100,2) but I receive the "There's a problem with your formula" error.

="ROUND(COUNTIF("&U16&",""LATE"")/COUNTA("&U16&")*100,2)" This adds the range but doesn't work as a function.

Any help would be appreciated.

 

[Snakehips]

It's not entirely clear to me but, are you perhaps wanting to use INDIRECT ?

As in. =ROUND(COUNTIF(INDIRECT(U16),"LATE")/COUNTA(INDIRECT(U16))*100,2)

 

[Belair58]

Snakehips,

That worked great. I'd never used Indirect before, very interesting. Thanks