bademployee
Board Regular
- Joined
- Aug 19, 2010
- Messages
- 184
Hi all
Have been using:
I have to remember to change the year each year....any ideas how to overcome this?
The user inputs the year in "Journal!V4" on another sheet if it's of any help.
Thanks for any help in advance.
Mark
Have been using:
Code:
=SUM(Journal!$BY$9:$BY$504)-(SUMIF(Journal!$J$9:$J$504,">31/01/2014",Journal!$BY$9:$BY$504)+SUMIF(Journal!$J$9:$J$504,""<1/1/"2014",Journal!$BY$9:$BY$504))
I have to remember to change the year each year....any ideas how to overcome this?
The user inputs the year in "Journal!V4" on another sheet if it's of any help.
Thanks for any help in advance.
Mark