Edit, Copy of Conditional Sum

Annie S

New Member
Joined
Oct 30, 2005
Messages
25
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!
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
Annie S said:
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,799
Messages
5,574,377
Members
412,589
Latest member
ArtBOM
Top