# Percentage within two rows

Options

Can someone help me with a formula to determine what % is "Reps in NV" of the "Total Reps"?

• ✭✭✭✭✭✭
Options

In the % Column enter this formula:

=count@row/count\$1. It will calculate the percent of total for each.

There are lots of good training materials and videos in the learning center ot available on YouTube. You'll have the hang of this in no time.

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭
Options

Hi @Erick Gutierrez

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

Good morning @Erick Gutierrez ,

Again, happy to help. The formulas you're looking for are below but I don't understand your table, more below formulas.

% of 25 Taking calls of 40 Total Reps: in the % of total row below 25, insert: =MA3/Count1

% of 21 Taking calls of 40 Total reps: in the % of total row below 21, insert: =COMM3/Count1

As for your table, you asked to calculate a percent of the total taking calls. However, Competent + Learning + Taking Calls doesn't equal 40 in any of the columns. Granted, I don't know what MA, COMM, ASO2 or WP represent so this may make sense to you. Are you getting the right counts in each column and row of that table?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭
Options

In the % Column enter this formula:

=count@row/count\$1. It will calculate the percent of total for each.

There are lots of good training materials and videos in the learning center ot available on YouTube. You'll have the hang of this in no time.

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• Options

Thank you very much! That helped, and makes sense. Would you be able to help me with the formulas for the % of 25 Taking calls of 40 Total Reps, 21 Taking calls of 40 Total reps, for the life of me, I can't figure it out! also do you have the link for the videos that you mentioned? I hope you can help! Thanks again!

• ✭✭✭✭✭✭
Options

Hi @Erick Gutierrez

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

Good morning @Erick Gutierrez ,

Again, happy to help. The formulas you're looking for are below but I don't understand your table, more below formulas.

% of 25 Taking calls of 40 Total Reps: in the % of total row below 25, insert: =MA3/Count1

% of 21 Taking calls of 40 Total reps: in the % of total row below 21, insert: =COMM3/Count1

As for your table, you asked to calculate a percent of the total taking calls. However, Competent + Learning + Taking Calls doesn't equal 40 in any of the columns. Granted, I don't know what MA, COMM, ASO2 or WP represent so this may make sense to you. Are you getting the right counts in each column and row of that table?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• Options

Thanks again Mark! Once again I learned something new. Yeah I totally see what you're saying about the Competent +Learning +Taking Calls not adding up, I'm actually adding Competent + Learning= Taking calls. This community is so helpful, I can't wait to continue to learn on here, now if I could just come up with an outlier formula.

• Options

You've been amazing, Mark! I spent most of the day yesterday trying to figure this out. This would be the last piece of the puzzle:

Could you help with one last formula to determine the %'s of Column CA Tier for CA, CA1,CA2, and CA3

• ✭✭✭✭✭✭
edited 12/08/20
Options

Sure Erick,

The formula in the % row would be:

CA =MA7/sum(\$MA\$7:\$WP\$7)

COMM =COMM7/sum(\$MA\$7:\$WP\$7)

ASO =ASO7/sum(\$MA\$7:\$WP\$7)

WP =WP7/sum(\$MA\$7:\$WP\$7)

Copy and paste that into the other 3 columns. Then change the 1st MA to COMM, ASO, and WP. The "\$"s in the formula keep that range from changing when you copy it across - a static reference.

Based on your image I'm assuming that the counts are in Row 7. If they aren't you'll need to change the number in the formula to the right row.

Work?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!