Why does this formula work?
=SUMIFS(Sheet1!F:F,Sheet1!C:C,Sheet2!A5,Sheet1!B:B,">=41448",Sheet1!B:B,"<=41454")
But as soon as I change the values to referenced cells, it does not...?
=SUMIFS(Sheet1!F:F,Sheet1!C:C,Sheet2!A5,Sheet1!B:B,">=B1",Sheet1!B:B,"<=B2")
Thank you in advance.
Bookmarks