mardi 23 juillet 2019

Google Sheets match regexextract and sumif

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