|
Is there a way to apply string manipulation functions to array blocks? I was trying to do this: quote:1 Dog asdf Sum the left column if the right column starts with "dog" in case insensitive. I guess you can do this with multi-column retardation and (LOWER, ISERROR, FIND, IF) functions pretty trivially... is there a way to do this in a oneshot? Incidentally it turns out you can do a case sensitive with SUMIF(B1:B5, "dog*", A1:A5) - where is criteria stuff like this documented?
|
# ¿ Oct 2, 2009 00:55 |
|
|
# ¿ Apr 28, 2024 06:05 |