Difficulty 4 of 5 · about 5 min
Sum sales between a start date and an end date held in cells
Invoices are in A2:C11: invoice date in column A, customer in column B and amount (AED) in column C. The start date of the reporting window is in F2 and the end date is in G2. In H2, write a formula that adds up the amounts of invoices dated on or after the start date AND on or before the end date. Both boundary dates are included, and both dates must be read from the cells.
Loading grid…