Date Reference Problem in SUMIFS

[jdunlap]

I'm using SUMIFS to return labor hours if criteria is met for name, labor category, etc. Works just fine until I add the section for "less than" a cell that contains a date. Current formula below. Might be a quote error; might be a date format issue; ???? Any help would be appreciated!

=sumifs('Sheet2'!$P$1:$P$1000,'Sheet2'!$B$1:$B$1000,'Sheet1'!A15,'Sheet2'!$G$1:$G$1000,'Sheet1'!C15,'Sheet2'!$M$1:$M$1000,"<'Sheet1'!$A$10")

Where Sheet 1 Cell A10 is a date.

 

[T. Valko]

I'm using SUMIFS to return labor hours if criteria is met for name, labor category, etc. Works just fine until I add the section for "less than" a cell that contains a date. Current formula below. Might be a quote error; might be a date format issue; ???? Any help would be appreciated!

=sumifs('Sheet2'!$P$1:$P$1000,'Sheet2'!$B$1:$B$1000,'Sheet1'!A15,'Sheet2'!$G$1:$G$1000,'Sheet1'!C15,'Sheet2'!$M$1:$M$1000,"<'Sheet1'!$A$10")

Where Sheet 1 Cell A10 is a date.

Try it like this...

=SUMIFS(Sheet2!$P$1:$P$1000,Sheet2!$B$1:$B$1000,Sheet1!A15,Sheet2!$G$1:$G$1000,Sheet1!C15,Sheet2!$M$1:$M$1000,"<"&Sheet1!$A$10)

 

[jdunlap]

Perfect! I knew it was probably a quote or format issue, I just didn't know what the proper syntax was! Thanks much!!

 

[T. Valko]

Perfect! I knew it was probably a quote or format issue, I just didn't know what the proper syntax was! Thanks much!!

You're welcome. Thanks for the feedback!