Sumifs vba formula with userform

[chintu]

Hi Team,

In sheet2 I have some data for 2017 and 2018 from January to December of product A to Z

Here I take the balance of products using sumifs (=SUMIFS(Sheet2!D:D,Sheet2!A:A,"2018",Sheet2!B:B,"JANUARY",Sheet2!C:C,F4) formula in sheet1.

I want to do this activity as a macro using user-form like:-

I if click 2018 and January month means I will get only my selection data for the product.

USER_FORM:-
[TABLE="width: 175"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD="align: right"]2018[/TD]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2017[/TD]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD]JANUARY[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD]FEBRUARY[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD]MARCH[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD]APRIL[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD]MAY[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD]JUNE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD]JULY[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD]AUGUST[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD]SEPTEMBER[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD]OCTOBER[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD]NOVEMBER[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD]DECEMBER[/TD]
[TD]

[/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott T]

You can not host a picture from your computer. You will need to use a hosting site like

Imgur​

or other image hosting site.

 

[chintu]

That picture is nothing but Checkbox