Nura Ibrahim needs the October revenue figure calculated in Excel to cross-check against the Finance system. She specifically wants to see the difference between gross revenue (all orders) and net revenue (excluding cancelled, returned and refunded orders).

In Meridian_Data.xlsx, in a new sheet called Oct Revenue Analysis: - Use SUMIFS to calculate total order revenue for October 2023 (all statuses) - Use SUMIFS to calculate total revenue for October 2023 excluding cancelled, returned and refunded orders - Show the gap between the two figures - Format all numbers as Nigerian Naira with thousand separators

Use the order_date column in the Orders sheet and the total_naira column.