Need to build a formula that grows each month
Good Afternoon All,
I have a formula that has to build for each month
I already have the formula for January and it works
IF({January A Sum} <> 0, {January A Sum}, {January F Sum})
The February formula is bigger
IF Jan A Sum and Feb A sum <> 0, it would equal Jan A Sum + Feb A sum
If Jan A sum <> 0 and Feb A sum = 0, Jan A Sum + Feb F sum
Else it is Jan F Sum + Feb F Sum
When you get to March you have to add more
If Jan A Sum and Feb A Sum and March A Sum <> 0, Jan A Sum + Feb A Sum + March A Sum
If Jan A sum and Feb A sum <>0 and March A Sum = 0, Jan A Sum + Feb A Sum + March F Sum
If Jan A sum <>0 and Feb A Sum and March A Sum = 0, Jan A Sum + Feb F Sum + March F Sum
Else Jan F Sum + Feb F Sum + March F Sum
This equation will grow each month if I cannot find a better way to handle this. Anyone have any help to offer?
Just for Reference the sums are referenced on another sheet and are not side by side to one another on the sheet.
Caroline
Answers
-
Hi Caroline,
If you do not want a lengthy formula, you can create helper columns in the source sheet with different scenarios and even do up the totals. You can then pull the absolute value into your new sheet.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
Don't want to add a bunch more columns just to get a number, I will keep working on it and see what else I can come up with.,
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!