Hello,
Could you please support to get the formula for Month to date calculation based on month selection from the list box. Currently I have made with SUMIFS formula and it is getting too long due adding each month with if condition. Here is the current formula. is there any way to reduce or replace it this. the sample file has multiple columns selection also.
IF(K4="jan",SUMIFS($H$2:$H$273,$A$2:$A$273,$K$3,$D$2:$D$273,$J8,$B$2:$B$273,K$7,$C$2:$C$273,$K$4),IF($K$4="feb",SUMIFS($H$2:$H$273,$A$2:$A$273,$K$3,$D$2:$D$273,$J8,$B$2:$B$273,K$7,$C$2:$C$273,"jan")+SUMIFS($H$2:$H$273,$A$2:$A$273,$K$3,$D$2:$D$273,$J8,$B$2:$B$273,K$7,$C$2:$C$273,$K$4),IF($K$4="mar",SUMIFS($H$2:$H$273,$A$2:$A$273,$K$3,$D$2:$D$273,$J8,$B$2:$B$273,K$7,$C$2:$C$273,"jan")+SUMIFS($H$2:$H$273,$A$2:$A$273,$K$3,$D$2:$D$273,$J8,$B$2:$B$273,K$7,$C$2:$C$273,"feb")+SUMIFS($H$2:$H$273,$A$2:$A$273,$K$3,$D$2:$D$273,$J8,$B$2:$B$273,K$7,$C$2:$C$273,$K$4),0))).
The sample file is attached.
regards,
Jamaludheen
Bookmarks