Formula  IF/OR
Hello,
I am attempting to take the SUM of one cell and divide it by a range of other cells to get a percentage output.
However, when creating the formula I am receiving an "#Incorrect Argument" error. I need the range in the column(s) because the column "Region Name" will fluctuate with the entries that are made from the source sheet to my metrics sheet (screenshots). So I am attempting to get a utilization percentage of each "Deal Type" per "Theater"
=IFERROR(SUM(Value@row / Value60:Value95, 0))
I have also attempted to do the formula this way as well, I think I am missing a variable but not 100%. This formula does not give an error but I am not getting the percentage from the total of all the AMER's which according to my calculations would be 27% under Theater AMER (row) in the Consulting Cell.
=IFERROR(SUM(Value61:Value96, "AMER", "Consulting" / Value@row), 0)
I would need it to look like this when all said and done
I am ultimately trying to create a dashboard so I think the information needs to be side by side maybe I need to create a different metric(s) sheet? Maybe rethink the entire structure for the percentages....?
So that will have the running totals of each theater divided by each deal type.
Any guidance or assistance is greatly appreciated
Thank you!
Adriane
Best Answer

Don't you just want
=Value@row / SUM(Value60:Value95) ?
So
=IFERROR(Value@row / SUM(Value60:Value95), 0)
If you are then dragging the formula
=IFERROR(Value@row / SUM(Value$60:Value$95), 0)
will keep your range from moving as you drag
Let me know how that goes
Answers

Hi @Adriane Price
Hope you are fine if you can send an excel sample i can design it for you as full application on smartsheet ( reports, Dashboard, input form ...atc)
please call me on my Email: [email protected]
or on my WhatsApp ( +966 530 97 3300 )
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Hello @Bassam.M Khalil 
Thank you I appreciate the offer, I have it almost all built out I am only stuck at the section I indicated and the information I do have is sensitive so I will not be able to send a sample.
Adriane

Don't you just want
=Value@row / SUM(Value60:Value95) ?
So
=IFERROR(Value@row / SUM(Value60:Value95), 0)
If you are then dragging the formula
=IFERROR(Value@row / SUM(Value$60:Value$95), 0)
will keep your range from moving as you drag
Let me know how that goes
Help Article Resources
Categories
Check out the Formula Handbook template!