count the same data & Cells as drop down menu value

Hi Danny,

there are multiple ways, none of them is fully automatically.

Here one without formulas, but with a few manual steps that you have to do to get this graph.

Normally it looks something like this

You could add a filter to the Person column, it will only show rows where the name in Person "Is distinct".

With active filter it will look like this, every name is shown only once.

Pro: You don't have to add the names to a special list

Negative: For the graph you have to activate the filter, for the input you have to deactivate the filter

Regards Ralf

Hi Dannyk22,

here an option for question 1:

Use the function COUNTIF - Apple Support to count the names

Formula for cell C2=COUNTIF(B,"="&B2)

Now drag this formula down or use Autofill to populate the formula to all rows of your table

This will give you the total count for each name

Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.

Hope this will solve your question, please let me know if this worked for you or if something in unclear.

Regards Ralf

Hi Dannyk22,

here an option for question 3:

Unfortunately you can not easily change the color for the positive / negative values.

But you can split them and use chart type "2D Stacked Column"

First split them in positive / negative values

Formula for C2=IF(B2≥0,B2,0)

Formula for D2=IF(B2<0,B2,0)

Then populate these formulas down to the end of your table.

Now create a 2D Stacked Column chart and change the colors.

Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.

Hope this will solve your question, please let me know if this worked for you or if something in unclear.

Regards Ralf

Hi Dannyk22,

here an answer for question 2:

Sorry but Numbers does not have an option to link a column to a Pop-Up Menu and automatically update the Pop-Up Menu as soon as the content of the column will change.

But you can select all cells that use this specific Pop-Up Menu and then you can change all these cells together.

As long as they are all in one column it is easy, if they are in different places in your table it will get difficult.

Hope this will solve your question, please let me know if this worked for you or if something in unclear.

Regards Ralf

Or you create a new table with all names and use the XLOOKUP function to get the number for the specific name

Pro: You don't have to switch filter on and off

Negative: You have to ensure that you have all names in your second table

There is no right or wrong, it is a personal decision. Based on how often you add new names and how often you need to get a correct graph.

Regards Ralf

Or you could have a look into Pivot Tables.

They can help with many things and create very quick a summary.

One big negative point on Pivot Tables is that they don't update automatically!

You would have to manually select update before you review the graph.

As a positive you don't have to calculate the total for each name, because this is done by the Pivot Table.

https://www.youtube.com/results?search_query=apple+numbers+pivot+table

Regard Ralf