samedi 18 avril 2015

Dynamic range in sum formula with constraints

I'd like to sum up some data within the current month but only until the current date.


The sheet looks something like this:


enter image description here


So there are 2 things to consider:




  • I'd like to not use the static formula =SUM(B32:B59) to sum up all values from february but rather have some kind of dynamic formula which automatically sets the ranges of the SUM to the first & last date of the month in which the sum formula "resides".




  • The end of the sum range should be constrained to not exceed the current date




Is this possible at all and if so, how?


Thanks


Aucun commentaire:

Enregistrer un commentaire