Hey there,
I am trying to get the running year to date sum of the values in row 5 if todays date is less than or equal to that month so then to include that corresponding months value into the equation and give us a running total ytd sum
=SUMIF($C$1,"<="&Months, Money_In)
This is formula I'm using. C1 is todays date, less than or equal to the reference group of Months (jan-dec, w/ the year etc but calculated as the last day of the month (its true value) using eomonth) should then output the sum of the corresponding money in columns values
Your help on this is greatly appreciated, Thanks!
-Austin
Bookmarks