Use cell content as values for a weighted.average formula in google sheets
I want to use the content of a cell as values of weighted.average formula in google sheet.
Example:
Cell A1 manually input values: 10,2,50,3,60,1 That means 10x2 + 50x3 + 60x1
Cell F1 put the formula: =weighted.average( [contents from A1] ) The result must be 38.33
I don't know how to concatenate this.
I've tried to use =weighted.average(text(A1)), =weighted.average(cell("contents",A1))
No results
Solution
try:
=LAMBDA(ax,AVERAGE.WEIGHTED(QUERY(ax,"SELECT * SKIPPING 2"),QUERY({2^99;ax},"SELECT * SKIPPING 2 OFFSET 1")))(TRANSPOSE(SPLIT(A1,",")))
-
- Create connected drop-downs in google sheets where value can be present only in one drop-down
- How to debug a spreadsheet custom function in google script?
- Google Sheets App Script: Trigger on a copied sheet
- Convert each name and corresponding data into separate columns
- Extract randomly data according to multiple criteria
- Google Sheets Count Unique Values
- How to add prefix and suffix text to to part of text in an arrayformula
- Google Apps Script, Google Sheets - Getting Spreadsheet ID and Sheet ID programmatically
- Jump From Cell A to Cell B in Google Sheets without hardcoding
- Is there a way to copy from a Google Sheets that is copy locked?
- How to import data from multiple sheets into one sheet with BYROW and LAMBDA?
- How do I pick a random cell in Google Sheets based on the cell next to the target list of data?
- Google Sheets to Calendar - something wrong with the syntax of the date
- Match data based on id between sheets of one googlesheet &extract alphanumeric values in separate column
- Randomizing the contents of a list in Google Sheets
- How to add "today" to date validation via Apps Script?
- My function is only copying the first line. I would like it to copy all line within a range. E.g ("I7:I24")
- Ticker symbols supported by googlefinance function
- Pagination error while accessing data using Google Apps Script
- Cannot extract month name, in specified language, from date
- Time trigger .atDate using a cell as a reference
- How do I increment a Google Sheets range via getRange?
- Google Sheets formula to split a cell that contains a null value
- How to Format the Email Body Properly When Creating Gmail Drafts from Google Sheets Data in Google Apps Script?
- Using setvalues() For Scattered Ranges
- How to test type of range parameter in Google Spreadsheet script?
- How do I set the range to change automatically in Google Sheets API?
- Copying data from a sheet to another with conditions
- Arrayformula and Sum in Google sheets
- Export Single Sheet to PDF in Apps Script