User Profile
S-C-K
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Formula help needed
I need help on a formula to sum values across columns with certain criteria. I need to sum all the As, all the Bs, etc across many columns of contracts. I've simplified my example attached. I've tried various Lookup formulas, SUMIfs, and others with no success. Can anyone help?65Views0likes4Comments- 2KViews0likes0Comments
- 2KViews0likes0Comments
Re: changing scales
JKPieterse The project below was scored on 120 points. I need to convert 59/120 to a 100 point scale. Some projects were scored out of 95 points, etc. I'm thinking a data table would do this for me (I did the below conversion manually) but haven't figured it out yet. Thank you for any assistance you can provide!2.1KViews0likes8Comments
Recent Blog Articles
No content to show