Hello everyone,
I've been working on a stock analysis spreadsheet and am getting a little stuck trying to create a weighted score. In the spreadsheet linked below, I've got a couple of columns:
- Answer (this is a "Y" or "N")
- Score (if "Y," then 1; if "N," then 0)
- Weight (either 1 or 2..might change these up later)
In cell C49, I've got the Total Score as a percentage of "Y" answers. I'd like to integrate a Weighted Score in cell D49, but I'm getting stuck using the SUMPRODUCT formula to make it a percentage like Total Score.
Any help/direction would be much appreciated!
Spreadsheet link: Upload files for free - Stock Research.xlsx - ufile.io
I've been working on a stock analysis spreadsheet and am getting a little stuck trying to create a weighted score. In the spreadsheet linked below, I've got a couple of columns:
- Answer (this is a "Y" or "N")
- Score (if "Y," then 1; if "N," then 0)
- Weight (either 1 or 2..might change these up later)
In cell C49, I've got the Total Score as a percentage of "Y" answers. I'd like to integrate a Weighted Score in cell D49, but I'm getting stuck using the SUMPRODUCT formula to make it a percentage like Total Score.
Any help/direction would be much appreciated!
Spreadsheet link: Upload files for free - Stock Research.xlsx - ufile.io