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 specifics ie =1 <>1
example: D has cells 6 thru 10 with "Apple" 11,12,15 "Peach" and E has a used defined date in cells E 6,7,11,15 it should answer 4 (I don't care in this column how many apples or peahes) just how many have dates associated.
Hope someone can help, I've spent a couple days on this and still get the wrong answer...
Thank you in advance.
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 specifics ie =1 <>1
example: D has cells 6 thru 10 with "Apple" 11,12,15 "Peach" and E has a used defined date in cells E 6,7,11,15 it should answer 4 (I don't care in this column how many apples or peahes) just how many have dates associated.
Hope someone can help, I've spent a couple days on this and still get the wrong answer...
Thank you in advance.