1down votefavoriteI 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 pointst = technical fall and is 5 team pointsm = major decision and is 4 team pointsI 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?

Level 1

1 points

How do I assign numeric values to text in Numbers and add them?

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?

iPhone 6s Plus

Posted on Jan 14, 2016 10:30 AM

There are no replies.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How do I assign numeric values to text in Numbers and add them?

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up