Hello, I have been looking around for a way to do this and haven't quite found what I am looking for. I have a list of entries, each with a date and a number associated with that date. Currently, these dates are stored as Excel dates, and I would like to keep it that way if possible. What I am trying to do is do something like this "=SUMIF(Sheet2!A2:A16, "1/1/2009",Sheet2!B2:B16)", but instead of it needing to be the first of the month, I would like to have any day of the month be valid. However, =SUMIF(Sheet2!A2:A16, "1/*/2009",Sheet2!B2:B16) does not work, likely due to the value actually being a simple date number.
I imagine this is possible using SUM(IF()), but I could not figure it out.
Any help would be greatly appreciated, and I have attached a simple Excel sheet example that might explain better what I am trying to do.