I need to sum a dollar figure between a date range based upon a text entry in another column
Dates are a2:a40000
Dollar Figure is d2:d40000
M2:M40000 is a Y or a N
Date Range is X2 as the start date and Y2 as the end date
I need to add up the dollar figure between the date range if M2:M40000 is marked with a "N"
I think I need to use Sumifs, but I just can't figure it out. Please help.
This is the formula I am trying to work with. It is obviously not even close
=sumifs(d$2:d$40000, M2:m40000"="N,a2:A40000 ">=x2, A2:a40000<=Y2)
Dates are a2:a40000
Dollar Figure is d2:d40000
M2:M40000 is a Y or a N
Date Range is X2 as the start date and Y2 as the end date
I need to add up the dollar figure between the date range if M2:M40000 is marked with a "N"
I think I need to use Sumifs, but I just can't figure it out. Please help.
This is the formula I am trying to work with. It is obviously not even close
=sumifs(d$2:d$40000, M2:m40000"="N,a2:A40000 ">=x2, A2:a40000<=Y2)