I have been fighting with SUMIFS for the last few days and finnaly figured out WHAT was wrong but I am hoping someone can tell me WHY
When i put together the table below I typed "Week_01" into cell M6 then I grabbed the little corner doohickey and dragged to the right
This Auto enters...