Count range of cells in one column if it includes a date in another column

New Contributor

See attached.  I want to count the "#of Jobs column if there is a date in the "Transfer Submission Date," what formula is useful.  I am just a intermediate excel user starting to use more of logical formulas.  I appreciate your help.

3 Replies


That could be

Perfect! Thank you. Can you share how I can get better at formulas? Is there a MS Excel training specifically for learning formulas?


Sorry, I don't know exact ones, but they definitely exists. You may start from learning templates - in your Excel File->New and here you find lot of them