Edit, Copy of Conditional Sum

[Annie S]

I am doing a recap sheet of my stores sales by month. I have no problem getting the sum of the first month. Then I copy the formula and put it into the next month and edit the date number to get this months total.
It keeps returning 0.
Should be simple, feeling very confused. Any ideas, would be greatly appreciated!

 

[Aladin Akyurek]

I am doing a recap sheet of my stores sales by month. I have no problem getting the sum of the first month. Then I copy the formula and put it into the next month and edit the date number to get this months total.
It keeps returning 0.
Should be simple, feeling very confused. Any ideas, would be greatly appreciated!

If it's a formula constructed with Conditional Sum Wizard, you need to confirm it with control+shift+enter, also after an edit.