Occasional Visitor
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!
1 Reply


Please include your Excel version, sample file, and a bit of context to help others answer your question:

Welcome to your Excel discussion space!


Thank you for your understanding and patience


I wish you much success in your project