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
Check out the Formula Handbook template!