excel translation

Maricar Mikin

Maricar Mikin ✭✭

11/11/20 in Formulas and Functions

=+AVERAGE(SUMPRODUCT(F$13:F$19,$D$13:$D$19)/SUM($D$13:$D$19),F20,F21)

0 ·

Best Answer

Mark Cronk ✭✭✭✭✭✭

11/12/20 Answer ✓

Does this answer your question?
https://community.smartsheet.com/discussion/10176/weighted-average-sumproduct

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
5 · Share on Facebook Share on Twitter

Answers

Mark Cronk ✭✭✭✭✭✭

11/12/20 Answer ✓

Does this answer your question?
https://community.smartsheet.com/discussion/10176/weighted-average-sumproduct

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
5 · Share on Facebook Share on Twitter
Bassam Khalil ✭✭✭✭✭✭

12/09/20

Excellent @Mark Cronk

PMP Certified
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Index Collect with multiple criteria including dates.
Greetings All - I've got a sheet of data that contains Employees, commitments (including when they are on PTO) and the dates they start and finish those project assignments. In the below screenshot you can see that Jane is scheduled to be on the Apex project between 4/11 and 4/14. I'm trying to write an index collect…
how do I create a formula to copy a date "Task End date" from the previous row
Dragging cells increases the number when trying to copy
When I have a value, say a date, in a cell, I highlight the cell then drag the lower right corner down to copy the date to the cells below, it's increasing the date by one each time instead of just copying it. How do I fix this so I can just drag down to copy cells exactly as they are in the top cell?