Adding values together with different conditions.
Hi everyone,
So what I am trying to do is compare job numbers from different days of the week, and if those numbers are the same then add the Per Diem values together. Here's the formula that I'm using so far. By the way the formula resides in Column Job 1.
=IF(OR([Monday Job]@row = [Tuesday Job]@row, [Monday Job]@row = [Tuesday Job]@row, [Monday Job]@row = [Wednesday Job]@row, [Monday Job]@row = [Thursday Job]@row), [Per Diem Day 1]@row + [Per Diem Day 2]@row + [Per Diem Day 3]@row + [Per Diem Day 4]@row + [Per Diem Day 5]@row, "")
This is working in a way, as it is adding together all the Per Diem values, however it is not making the distinction if the job numbers are the same or not. Any help would be appreciated. Thanks
Also I've attached a screenshot of my sheet if that helps any, Thanks again
Answers
-
Hi, @Andrew Skaggs , what should be the Reimburse amount when Monday Job is blank?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!