SUM(), SUMIF(), and SUMIFS() explained for Apple Numbers! 

Glad it helped! Thanks for watching!

That’s great to hear!! Glad it was helpful and thanks for watching!

Thanks so much for the kind words. Glad you liked it. I’ll definitely be doing more Numbers videos in the future. Thanks for watching!

Thanks for the kind words! I’m glad this video was able to help you out. Thanks for watching!

Exactly 👍 👏👏👏👏👏🏆

You're very welcome! Thanks for watching!

Thanks so much! Glad it was helpful!

That’s great to hear! Glad this was helpful. Thanks for watching!

Thanks so much! I appreciate the kind words. Thanks for watching!

You are so welcome! Thanks for letting me know and thanks for watching!

Glad it helped! Thanks for watching!

Glad it was helpful!

Thanks so much for the kind words - much appreciated. And thanks for watching!

Glad it was helpful! Thanks for watching!

Thanks! Very cool! Good luck!

Glad you liked it! Thanks for watching!

Awesome, thank you!

It’s so true. I haven’t had to use Excel in years.

Thanks for the feedback! I'll look into that and get back to you.

I'll add it to the list! Thanks!

Hello and thanks for the question. If I understand correctly, your condition is variable, so I'm assuming that condition is the value from another cell. I did some testing and this worked for me: =SUMIF(A1:A5, C1, B1:B5) So in the above statement: A1:A5 are the test values C1 is the cell containing the condition which is variable and can change B1:B5 are the sum values So in your example, if C1 contained the text "AJUSTE" then this would sum all values if A contains "AJUSTE". Hope this works for you. Thanks for watching!

You're welcome! Thanks for watching!

You’re welcome 😊

Hi there, thanks for your question. So are you adding a new row and want a cell within that new row to be included in a SUM cell? If that's the case then you need to add those rows within the selected SUM cell's range. Adding a row after the last row of the range won't expand the range. But if you add a row above the last row then the range will grow. The best solution is to always have a blank row at the end of the range and then you can always add a new row above that and it will be included in the SUM cell. If this isn't what you meant, please clarify. Thanks for watching!

HI there, this is a great question. I tried to do something similar to this a while ago and I couldn't find a way to embed another function within the Condition parameter of SUMIF. In your example, you want to test against the MONTH(). I played around and couldn't make it work. It feels like a very basic request and it's frustrating that it seemingly can't be done. If I ever find a way to do it, I'll let you know. Thanks for watching!

@@apple-a-day yess, very annoying they haven't made it possible. For now I just changed the cell to a text format and it works, out. Hopefully they can make an update someday. Thank you for taking the time to respond, I'll be sure to refer to your videos if I need help in the future! 💕💕💕

@@flavorbby Glad you found a workaround. Thanks so much and have a great day!

Hi there... sorry for taking so long to reply. Unfortunately I don't even have Excel installed on my Mac so I can't be of much help to you other than I would assume it must work similarly to how it works in Numbers - which is the same way it would work with SUMIF. Good luck!

This is a great question and Numbers sure doesn't make this easy. There does not seem to be any obvious way to indicate "=Development OR Support". But you can do it using the REGEX function (Regular Expressions). With REGEX there is a way you can check for multiple possibilities. Replace "=Development" with the following: REGEX("Development|Support", false) You can add as many options as you like, each one separated by the | (pipe symbol). Here's what the full statement looks like: SUMIF('Type', REGEX("Development|Support",FALSE), 'Time (Hours)') 'Type' and 'Time (Hours)' are the column names Hopefully this makes sense.

@@apple-a-day Amazing! Thank you for the fast response and great explanation. This one thing is a game changer for me.

@@kevy213 You're welcome! Glad I could help!

​@@apple-a-day I'm having a some issues with this formula. The REGEX function works great until I run into a situation where let's say I have "Development" and "Web Development" in the same column. If I use =COUNTIFS('Type',REGEX("Development|Support")) the formula gives me a larger than expected result because it's also including "Web Development" in the result because they both contain the common word Development. If I use =COUNTIFS('Type',REGEX("^(Development|Support)$")) the formula gives me a smaller than expected result because it appears to be excluding "Development" from the result, even though it continues to count "Support" Wrapping my REGEX criteria with "^(Criteria)$" seems to differentiate between similar words like "The" and "These" but not when the same words overlap like in my example above. Are there any work arounds that you know of? Much appreciated!

Problem solved.. I didn't realize it, but if you're using REGEX to filter by a specific word and that same word in your spreadsheet has a space after it, the formula won't count it in the result. A large portion of my dataset had a space at the end, which I didn't realize, and that is what threw off my result. The formula =COUNTIFS('Type',REGEX("^(Development|Support)$")) works perfectly to search a specific string of keywords. Just make sure your data is clean!

Hi there and thanks for the question. I looked into it and was surprised that I couldn't find a way to do this. It seems like an obvious request. I'll keep digging though. Thanks for watching!

Hi there, unfortunately Numbers does not have the equivalent of Excel Macros. You might be able to achieve some automated behaviour using AppleScript but it's completely different and can be extremely frustrating and will never match what you experience with Macros. This is definitely one feature I wish Numbers would adopt. Thanks for watching!

@@apple-a-day Then Number never beat Excel ..

@@SanjaySinghChauhan007 Yeah for this feature it sure does

Hi Steven, that's a tough one to figure out without having your spreadsheet in front of me. If you like you can email it to me and I'll take a look. Obviously remove any private information first or make a new one with dummy data that has the same issue.

I don't believe this is allowed. You can do a separate check for data in another column using SUMIFS, but that probably won't work for you because each condition that is checked in a multiple condition scenario must be TRUE.

I’m happy to help figure out what went wrong. Please provide the specific error message as well as the formula that caused it.