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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!