I created a spreadsheet to track my sons wrestling team. The text I'm trying to convert is Wp, Wt, Wm, etc. The first letter stands for Win and the second letter represents how the match was won.
- p = pin and is 6 team points
- t = technical fall and is 5 team points
- m = major decision and is 4 team points
I found this formula in a prior thread =SUM(COUNTIF(A1:G1,{"A","B","C"})*{1,2,3}) and it seems perfect. Here is the formula I came up with based of the previous;
=SUM(COUNTIF(C3:C27,{"Wp","Wt","Wm","Wd","Wf","Wbd"})×{6,5,4,3,6,6}), but I'm getting "The formula contains a number outside the valid range" error.
How can I correct this?
xsupposed to be a*? – Kyle Jan 14 at 18:13xis entered as*, it should work. This is an array formula. Have you usedCtrl+Shift+Enterto activate it so it will work? – CharlieRB Jan 14 at 18:25