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

@wdbrowne 

That could be

=SUMIFS(A2:A11,G2:G11,">1")
Perfect! Thank you. Can you share how I can get better at formulas? Is there a MS Excel training specifically for learning formulas?

@wdbrowne 

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

image.png