I’m trying to make a sumifs formula and it’s worked but after copying and pasting date from another sheet in I think something with the formatting went array. Now every time I type in =SUMIFS( and I select a column It fills as a:a or f:f instead of the appropriate syntax. I don’t know how to identify this problem. Any info helps. Thank you!