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

[wdbrowne]

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.

[#2]

@wdbrowne 

That could be

=SUMIFS(A2:A11,G2:G11,">1")

[#3]

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

[#4]

@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