How to count rows based on a column that has data and whether or not an additional column is null

Hi,  I'm trying to replicate a Countif function in Excel that will count the number of rows based on a item in one column, then I need to see if another column has any data or is null for that row. ...