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 on 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? |