Hello and good day,
I am having much difficulty getting this to work, I did some digging around and perhaps it's not the right function or even possible, but I can't quite find the right direction.
I have a table of transactions where column B will be dates such as "2017-09-01" and column H will be a transaction type. I would like to sum column F based on transaction type and date. Here are a few of the examples I have tried. The only way I can get it to sum is if I explicitly match the exact date. Example table below for clarity.
B H F 2017-09-01 Material 159.49 2017-09-15 Material 2045.59 2017-10-15 Labor 956.58
=SUMIFS('2017'!F1:F100, '2017'!B1:B100, "September", '2017'!H1:H100, "Material") - Sums to 0
=SUMIFS('2017'!F1:F100, MONTH('2017'!B1:B100), "September", '2017'!H1:H100, "Material") - Results in error
=SUMIFS('2017'!F1:F100, MONTH('2017'!B1:B100), 09, '2017'!H1:H100, "Material") - Results in error
=SUMIFS('2017'!F1:F100, '2017'!B1:B100, "*Sep*", '2017'!H1:H100, "Material") - Even a wildcard results in error
I am not sure what else to do... any advice very much appreciated.
Bookmarks