google-sheetspercentageweighted-average
Weighted percentages?
it's been a while since I have been working formulas and sheets and I can't get my brain to function.
I have two percentages: A) 120% and B) 179%, of which A) is weighted with 65% and B) is weighted 35%. I need to get the overall percentage of A) and B) taking the weighted percentages into account, meaning percentage A) is "worth" more with 65% and B) weigh only 35% into the overall percentage of these two.
How do I put this in a formula in sheets?
Solution
You may try:
=average.weighted(A3:B3,A2:B2)
- The download /back-up of Google scripts (.gs files) bounded to Google Spreadsheets
- How can I update this formula to work for all columns continuously to the right and not just the current 2 it's set up for?
- How do I retrieve the most frequent text value in a column that has cells with multiple entries in Google sheets?
- I do not understand the error message when I try to use QUERY() function in Google Sheets
- Google spreadsheets "VLOOKUP evaluates to an out of bounds range."
- Is there a way to display an image in an HTML table directly from a Google Sheets cell?
- Google sheets formula for showing remaining time per month for descending list of weeks
- working with dates and Calendar: need community help to improve sheet's efficiency
- Google Apps Event changeType undefined in Google Sheet
- Is there a method to display just a single cell value from a Google sheet on a Google site?
- Update PDF from Sheets and Keep Share Link and Permissions
- I want to repeat a line item in a google sheets form response based on a date value for consecutive dates
- How to show image in Google Sheets Sidebar based on active cell
- Sheet button ui formatting
- How to find the length of an array in Google Sheets?
- Formula not working when parsing set a dynamic range in Google spreadsheet formula ARRAYFORMULA
- Embed Published Google Sheet in GitHub md file
- Google Sheet: How do I pass in ARRAYFORMULA into QUERY?
- Datetime comparison query
- QUERY command WHERE parameter not finding match - format error?
- Sidebar HTML form not submitting data to Google Sheet
- Calculate the number of times groupings of three zeros (0's) appear in a row
- Remove trailing ".00" from numbers in Google Sheets
- Google Sheet Sidebar Data Entry Sidebar Form Pass Value
- Is it possible to bulk replace strings in an Excel file via API?
- Split string and get last element
- How to decode cloudflare email in Google sheets
- Sorting the string combined with arrayformula()
- Access other sheet's data from inside of ARRAYFORMULA
- how to sort a string contains list of number in google sheet?