Belair58
Board Regular
- Joined
- Mar 31, 2005
- Messages
- 95
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.
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.