Task #31

Large orders

An order is considered large if it's above the threshold in G1. Calculate:

  • in G2, how many large orders there were;
  • in G3, their total amount.

The threshold will change, so take it from the cell.

Task #31
Large orders

An order is considered large if it's above the threshold in G1. Calculate:

  • in G2, how many large orders there were;
  • in G3, their total amount.

The threshold will change, so take it from the cell.