If you use this variation, you won't need to use CTRL+SHIFT+ENTER to make it an array formula.
Regular formula:
=SUMPRODUCT(LEN(BO5:BO14)-LEN(SUBSTITUTE(UPPER(BO5:BO14),"U","")))
Is that something you can work with?
If you use this variation, you won't need to use CTRL+SHIFT+ENTER to make it an array formula.
Regular formula:
=SUMPRODUCT(LEN(BO5:BO14)-LEN(SUBSTITUTE(UPPER(BO5:BO14),"U","")))
Is that something you can work with?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks