Task #12

Days without sales

A sales rep kept a sales log for two weeks. On days without sales, the "Sales" cell is empty, and in the "Comment" column the rep sometimes left notes.

Calculate:

  • in F2, how many days had no sales;
  • in F3, how many days have a comment.
Task #12
Days without sales

A sales rep kept a sales log for two weeks. On days without sales, the "Sales" cell is empty, and in the "Comment" column the rep sometimes left notes.

Calculate:

  • in F2, how many days had no sales;
  • in F3, how many days have a comment.