Jtucker10278
Board Regular
- Joined
- May 14, 2017
- Messages
- 55
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 Week_02 Week_03 Week_04
then I use a SUMIFS formula
=SUMIFS(PNLQTY,PNLWEEK,M$6,PNLEMPLOYEE,$L7)
but when my sumifs formula references cell N6 that was "autocomplete" entered the formula does not work
but if hand type "Week_02" into cell N6 then my formula works
?????????????????????????
<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
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 Week_02 Week_03 Week_04
then I use a SUMIFS formula
=SUMIFS(PNLQTY,PNLWEEK,M$6,PNLEMPLOYEE,$L7)
but when my sumifs formula references cell N6 that was "autocomplete" entered the formula does not work
but if hand type "Week_02" into cell N6 then my formula works
?????????????????????????
L | M | N | O | P | |
---|---|---|---|---|---|
6 | Week _01 | Week_02 | Week_03 | Week_04 | |
7 | Amanda Holmes | 18 | 21 | 25 | 27 |
8 | Chuck Reynolds | 16 | 7 | 0 | 0 |
9 | Cody Harnish | 16 | 22 | 27 | 10 |
10 | Mark Lopez | 14 | 29 | 25 | 28 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
PNL_Numbers
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>
Workbook Defined Names
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>