Formula to consolidate data

[rizmomin]

Hello:

Please refer to attached file.
I have data as shown.
I will select the month in cell N1.
I need consolidated data for column K from 1 thru last day as shown in cell M1 for month choosen in N1 for
2014, 2015 & 2016.
In attached file choosen month is Oct, so need 2014, 2015 and 2016 data for 1 thru 15 from column K.
Note : Month number is in column B

Let me know if you have any questions.
Thanks.

Riz

[JohnTopley]

You were given an answer to a very similar query a few days ago: why can't you apply this to your new request?

After nearly 3000 posts you should be more "self-sufficient"

anyway ....

=SUMIFS($K:$K,$D:$D,">=" &DATE(O$1,MONTH($N$1&1),1),$D:$D,"<=" &DATE(O$1,MONTH($N$1&1),$M$1))

[rizmomin]

Hi John:

Thanks it works great.
Riz