Hello,
I m trying to have a live running total of my net profit for each month and I m unsure how to quite formulate it.
In column A I have an item description so that isn t needed for this. In column B I have the net profit of each item sold when it sells and column C is the the date sold when I sell the item.
How do I formulate a new cell, which I would call "March Net Profit" to look at column C for a specific date range (so for this month, 3-1-2019 through 3-31-2019) and find the sales that correlate in column B and give me the sum or total net profit for that date range? I have blanks in both column B and Column C, as there are items that are unsold still and could remain unsold until the next month and so on. I need the new cell to update as I enter info each month when items sell and course I'll have a new cell for each correlating month.
Hopefully I have worded this clearly enough do that the question is understood.
Thank you
I m trying to have a live running total of my net profit for each month and I m unsure how to quite formulate it.
In column A I have an item description so that isn t needed for this. In column B I have the net profit of each item sold when it sells and column C is the the date sold when I sell the item.
How do I formulate a new cell, which I would call "March Net Profit" to look at column C for a specific date range (so for this month, 3-1-2019 through 3-31-2019) and find the sales that correlate in column B and give me the sum or total net profit for that date range? I have blanks in both column B and Column C, as there are items that are unsold still and could remain unsold until the next month and so on. I need the new cell to update as I enter info each month when items sell and course I'll have a new cell for each correlating month.
Hopefully I have worded this clearly enough do that the question is understood.
Thank you