New here and hoping for help.
I have two column data "D6:D39" with 15 fixed dropdown choices and "E6:E39" which has dates (mm/dd/yy) users enter.
I only want excel to give me the total of the "D" range IF it has a date beside it. I have tried various formulas but all examples seem to require...