regexgoogle-sheetssplitgoogle-sheets-formulagoogle-query-language
Google sheets beginners course overall amounts of products in stock formula
im an absolute beginner, that has to do a test for a data analytics course.
I have to express in a formula: what is the overall amount of products in stock. everything on google sheets.
the link for the product list is here: https://docs.google.com/spreadsheets/d/1m67VmLZispyTwFTmPdppsdJNtbvnZsZK2LBCSchUWmU/edit?usp=sharing
My idea was to multiply the quantity per unit times the unit in stock. the problem i have is, that the quantity per unit column in E is also strings, so i dont know how to convert this column so that i can multiply it with the unit in stock column. also i am not sure if this formula is right in the first place. would be glad, if someone could help me.
Thanks a lot in advance!
Solution
try:
=INDEX(QUERY(REGEXREPLACE(SPLIT(REGEXREPLACE(E2:E;
"[a-zA-Z-\.]+"; ); " ")&""; "^$"; "1")*1;
"select Col1*Col2 label Col1*Col2''"))
- calculate mean of matrices having different lengths
- Get column and row position of nth element in a matrix
- Is there any authoritative documentation on R release nicknames?
- R Glassdoor Web Scraping
- Issue with graticule across 180° for several country/territory EEZs
- Separating grouped layers in a raster stack in terra
- Way to web-scrape a popular eSport website using R?
- Variance calculation warning: longer object length is not a multiple
- gratia::draw(): "'length.out' must be a non-negative number"
- Using Swift as custom engine in knitr and including all previous content
- convert source target value dataframe into a correlation matrix
- ggplot2 plotting a 100% stacked area chart
- Use string as formula for ipwtm function?
- interpolarization within groups with NA
- Multi-row x-axis labels in ggplot line chart
- How to do a SOAP request for EUR-Lex API with R?
- Make an alluvial plot
- Parameters for the ggplot theme function about legend.axis.line
- Error handling for tidyr hoist in API call dplyr pipe when column type changes between calls
- calculate distance between regression line and datapoint
- Colour picker input not updating output in R Shiny
- Order() in R - argument is missing, with no default
- How to plot geom_bar without showing multiple lines
- Computing only the n first rows of a distance matrix with R torch
- R: speeding up "group by" operations
- How to manipulate NetCDF-4 groups in R?
- How to convert categorial raster to mapped RGB values in R?
- How to add a hover-over tooltip to rhandonstable header cell?
- How to detect the right encoding for read.csv?
- Rcpp Rf_warningcall compiler warnings