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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!