Sum of Date Range

[DBlack16]

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

 

[Jeffrey Mahoney]

I would create two dynamic named ranges using the formulas below and naming them "DateRng" and "NetRng". I would put the beginning and ending date you want to sum in two different cells. Then using the Sumifs formula below referencing the named ranges.

DateRng
=OFFSET(Sheet16!$B$1,1,0,MATCH(1E+300,Sheet16!$B:$B)-ROW(Sheet16!$B$1),1)

NetRng
=OFFSET(Sheet16!$C$1,1,0,MATCH(1E+300,Sheet16!$B:$B)-ROW(Sheet16!$B$1),1)

Cell E1: 3/1/2019
Cell D1: 03/31/2019

Cell F1: =SUMIFS(NetRng,DateRng,">"&E1-1,DateRng,"<"&F1+1)

 

[jjasmith4]

In D2 make a formula that says "=MONTH(C2)" and fill that down. Then your formula would be "=SUMIF(D:D,3,B:B)", since 3 is March.