How do I pull the value of another cell for a formula?

[VizIzMe]

So here is my formula:

=SUMIFS('2018 Relief Oil Inv.'!$L:$L,'2018 Relief Oil Inv.'!$G:$G,"vape",'2018 Relief Oil Inv.'!$M:$M,">=7/6/18",'2018 Relief Oil Inv.'!$M:$M,"<=7/12/18")

My issue is I want the dates to be pulled from cell B1 and B2. When I type it as:

=SUMIFS('2018 Relief Oil Inv.'!$L:$L,'2018 Relief Oil Inv.'!$G:$G,"vape",'2018 Relief Oil Inv.'!$M:$M,">=B1",'2018 Relief Oil Inv.'!$M:$M,"<=B2")

it does not work and gives me a value of 0. I am wanting to be able to copy this formula into different columns and it pull from row 1 and 2 for dates so I dont have to manually change the date in the formula each time. Thanks for any help.

 

[dreid1011]

Try this:

">="&B1
"<="&B2

 

[Weazel]

try it this way...

=SUMIFS('2018 Relief Oil Inv.'!$L:$L,'2018 Relief Oil Inv.'!$G:$G,"vape",'2018 Relief Oil Inv.'!$M:$M,">="&B1,'2018 Relief Oil Inv.'!$M:$M,"<="&B2)

 

[VizIzMe]

Worked perfect! Thanks for the assist.