Solved

Need help with Math in Excel based on Selection

Posted on 2016-11-06
2
31 Views
Last Modified: 2016-11-06
EE Pros,

I have a great "Radar Chart" that EE Pros helped build.  I now need some help with the math and specific "Totals".  The attached Worksheet allows you to select or deselect specific columns or rows by doublechecking on a checkmarks.  You will see rows and columns appear and disappear as you select.  What doesn't change are the totals at the end of the columns and rows based on selection.  Can you take a look and see how the math would work (formula or within the macros) based on what is selected (i.e. visible)?  That is to say, if you deselect a row or column or multiple rows or columns, the totals will change.

Thank you in advance,

B.
RadarChartMultiVariableMath.xlsm
0
Comment
Question by:Bright01
2 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 41876354
Hi,

pls try in F6 and fill down an d fill right

=IF(AND($D6="P",F$4="P"),F57,"")

Open in new window

Regards
RadarChartMultiVariableMathV1.xlsm
0
 

Author Closing Comment

by:Bright01
ID: 41876502
Rgonzo,  Thank you!  Works great.  Just installed the formulas and it worked really well.....

Thanks again,

B.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question