I need assistsance with 2 different formulas.
In my spreadsheet,
Column A = Status
Column B = Assignee Individual.
Formula One...I need to calculate how many rows meet the criteria of Status = Active, and Assignee Individual is blank.
Formula Two...I need to calculate how many rows meet the criteria of Status = Active, and Assignee Individual is NOT blank.
Thanks!
In my spreadsheet,
Column A = Status
Column B = Assignee Individual.
Formula One...I need to calculate how many rows meet the criteria of Status = Active, and Assignee Individual is blank.
Formula Two...I need to calculate how many rows meet the criteria of Status = Active, and Assignee Individual is NOT blank.
Thanks!