ISO Correct Formula
Hi - Looking to total $ values in col. E. However, if a date is entered into col. D the value should be excluded from total.
Any ideas & thanks in advance!
Answers
-
Hi @Eve_Cherry
With as little info as you mentioned in your question - the following might be the answer:
=SUMIFS([ColE]:[ColE], [ColD]:[ColD], @cell <> "")
(Assuming ColD is a Date column so it either contains some date or is blank - which the above formula is checking)
Hope this helps
Vojtech
-
Hello @Vojtech Gajdos & thanks for your response.
Your assumption is correct -- Col D is a date column
The formula should not consider blanks because blanks are expected/acceptable. It should only check for dates in Col D.
As such, how should the formula be revised?
-
Hi Eve, so - the value in ColE should be included when the date IS blank? In which case the formula should simply change to:
=SUMIFS([ColE]:[ColE], [ColD]:[ColD], @cell = "")
Not sure though if I fully understand what you are trying to achieve 😀 (in your original post you mentioned that "if a date is entered into col. D the value should be excluded from total" but from your recent one it seems like the value should be included when there is a date entered. Anyway, use one or the other version of the formula.
Regards
Vojtech
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!