•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to make a SUM with multiple IF
Our take
Are you looking to sum a series of numbers while excluding specific values? If you want to calculate the total from 1 to 168 while skipping numbers that end in 9 or 0, you can achieve this with a combination of the SUM and IF functions. While the IFS function offers a more straightforward approach for multiple conditions, using nested IFs can provide the flexibility you need for this specific scenario. Let’s explore how to effectively implement this solution for your data.
I'm perfectly aware of the function IFS but here is the problem.
Let's say I wanna sum numbers from 1 to 168 skipping all number ending in 9, 0.
So something as follows:
11
12
13
14
15
16
17
18
21
22
...
27
31
32
....
See this as the first number indicating table number, and ending number as guest number.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#rows.com#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#financial modeling with spreadsheets#SUM#IF#IFS#numbers#table number#skipping#guest number#ending#1 to 168#range#mathematical function#Excel#count#data manipulation#conditional