MacMost Q&A Forum • View All Forum QuestionsAsk a Question

When I Sort How Can I Get My Tables To Automatically Update Without Any Errors?

when I update my spreadsheet and then sort the data I have three ranges for the data to be in. If the data moves from one range to another during the sort, how can I get it to recognize the data in a different range. I am pretty sure I have the most recent version of numbers I just got the mac a few months ago. I wish I could show you some screenshots on here to show you what I am talking about. Is there an IF THEN statement in numbers?
—–
Randy

Comments: 3 Responses to “When I Sort How Can I Get My Tables To Automatically Update Without Any Errors?”

    6 years ago

    I'm not sure what you are asking. You could use iCloud Drive, imgur.com or any file sharing service to post some images. There are plenty of ways to do IF-like functions, such as SUMIF. But I'm not sure what you are looking for. Check out Using the Numbers SUMIF Function.

    6 years ago

    Randy: OK. I see. So my original suggestion is what you want. You should be using SUMIF and AVERAGEIF functions and such. Look them up. Basically, you don't want to rely on the row positions of the data for calculations. Instead, have a column called "Group" or something with group names or numbers. Then, for instance, you can use SUMIF to get the total for something "if" the group matches a value.
    See the link in my comment above for a tutorial.

    It is hard for me to know what you are doing with those other tables. But if they are simply the same thing as the first table, the same people, then I'm not sure why they are in a different table. Why not have that data in the same table? But it is very hard for one person to understand another person's intent with spreadsheets coming at it with no context.

    If you want to be able to sort the first table and not sort the others, but still have the data match, then you could use LOOKUP with the name as the matching element. But I don't think that is what you are going for as the RPV column definitely looks sorted. So I'm confused.

    I'd just read up on both SUMIF and MATCH and get to know those functions as I'll bet your solution is with one of them.

    I have a tutorial on MATCH here: https://macmost.com/using-index-and-match-functions-to-look-up-values-in-numbers.html

Comments Closed.