SUMIFS Formula

[chaddres]

I am stuck on my SUMIFS formula.

This one works =SUMIFS('Combined Time'!K:K,'Combined Time'!F:F,'Main Worksheet'!$B$1,'Combined Time'!C:C,A2)
This one works =SUMIFS('Combined Time'!K:K,'Combined Time'!F:F,"<=45501",'Combined Time'!C:C,A2)
This one will not work =SUMIFS('Combined Time'!K:K,'Combined Time'!F:F,"<='Main Worksheet'!$B$1",'Combined Time'!C:C,A2)

Cell B1 on Main Worksheet has a value in it (45501). How can I use the reference to the cell with a less than or equal to?

 

[kvsrinivasamurthy]

Try.

=SUMIFS('Combined Time'!K:K,'Combined Time'!F:F,"<=" &'Main Worksheet'!$B$1,'Combined Time'!C:C,A2)

 

[hagia_sofia]

Hello, like this:

"<="&'Main Worksheet'!$B$1"

 

[Alex Blakenburg]

"<="&'Main Worksheet'!$B$1"

You missed removing the last "