Hi!
I have column A:A as date (dd/mm/yyyy) from Sales entry*, column B:B as amount and D1 through D12 are months & years (11/2018, 12/2018, 01/2019, 02/2019....)
How do I calculate the sales entry by month and year in column D?
*Note: No sales entry date if the amount is 0 or store is closed.
Thanks
I have column A:A as date (dd/mm/yyyy) from Sales entry*, column B:B as amount and D1 through D12 are months & years (11/2018, 12/2018, 01/2019, 02/2019....)
How do I calculate the sales entry by month and year in column D?
*Note: No sales entry date if the amount is 0 or store is closed.
Thanks
Last edited: