platform: google sheet.
D1 =3
E1 = 4
F1 = 7
D2=gg12
E2=13lkk
F2=1poi2
To sum numbers in d2:f2 is simple,
just use this formula by extracting the numbers in the cell:
=ArrayFormula(SUM(SPLIT(REGEXREPLACE(TRANSPOSE(D2:F2)&"", "[^\d\.]+", "|"), "|")))
but if I want to SUMIF(D1:F1,"<6", D2:f2) to get the answer 25, also means only calculate D2&E2 because of D1 and E1 are both <6, how to do that?
VBA or Google script is not allowed.
Splitting content to other cells and referring to them is not allowed.
Bookmarks