SUMIF(OR(???
I am trying to sum a column if either my Paid in 1st half in 2019 column is checked or my Paid in 2nd half in 2019 column is checked. I am trying to use a few different formulas without success.
Here are a two that I've tried:
=SUMIF(OR([Paid 1st half in 2019]:[Paid 1st half in 2019], [Paid 2nd half in 2019]:[Paid 2nd half in 2019], "1")[Estimated Pay #1]:[Estimated Pay #1])
=SUMIFS([Paid 1st half in 2019]:[Paid 1st half in 2019], "1" , [Paid 2nd half in 2019]:[Paid 2nd half in 2019], "1")[Estimated Pay #1]:[Estimated Pay #1]
This formula worked for just one of the criteria
=SUMIF([Paid 1st half in 2019]:[Paid 1st half in 2019], "1", [Estimated Pay #1]:[Estimated Pay #1])
Comments
-
=SUMIF([Paid 1st half in 2019]:[Paid 1st half in 2019], 1, [Estimated Pay #1]:[Estimated Pay #1])+SUMIF([Paid 2nd half in 2019]:[Paid 2nd half in 2019], 1, [Estimated Pay #1]:[Estimated Pay #1]) -SUMIFS([Estimated Pay #1]:[Estimated Pay #1],[Paid 1st half in 2019]:[Paid 1st half in 2019], 1 , [Paid 2nd half in 2019]:[Paid 2nd half in 2019], 1)
Something like that might work. I've spread it out a bit down below.
Sum if paid in first half
=SUMIF([Paid 1st half in 2019]:[Paid 1st half in 2019], 1, [Estimated Pay #1]:[Estimated Pay #1])+
Plus sum if paid in second half
SUMIF([Paid 2nd half in 2019]:[Paid 2nd half in 2019], 1, [Estimated Pay #1]:[Estimated Pay #1]) -
Minus paid in both halves
SUMIFS([Estimated Pay #1]:[Estimated Pay #1],[Paid 1st half in 2019]:[Paid 1st half in 2019], 1 , [Paid 2nd half in 2019]:[Paid 2nd half in 2019], 1)
-
Thank you!
I ended up using just the first part below and it worked!!! I don't know why I was trying to get all crazy when I could've done a simple formula lol.
=SUMIF([Paid 1st half in 2019]:[Paid 1st half in 2019], 1, [Estimated Pay #1]:[Estimated Pay #1]) + SUMIF([Paid 2nd half in 2019]:[Paid 2nd half in 2019], 1, [Estimated Pay #2]:[Estimated Pay #2])
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!