What is the error in this formula?
=arrayformula(regexextract(AE3:AG3,"Reflector"))
=array formula(--(regexextract(AE3:AG3,"[0-9]+")))
Data:
AE3 = 5 x Ecobulb 7W 3000K B22 Non-Dim (CFL Replace)
AF3 = 3 x Ecobulb 7W 3000K B22 Non-Dim (CFL Replace)
AG3 = 2 x Ecobulb 7W 3000K B22 Non-Dim (Reflector Replace)
I’m trying to search a specific string in a range of cells then get total.
Aucun commentaire:
Enregistrer un commentaire