Hey guys... First post here..
I have a simple problem..
I have four columns
Issued Date Value Date Company's Name Amount
03.09.2012 29.12.2012 AAAAAA € 750.00
27.12.2012 04.01.2013 BBBBBB € 7,020.00
27.12.2012 04.01.2013 CCCCCC € 11,700.00
27.12.2012 04.01.2013 DDDDD € 1,000.00
27.12.2012 07.01.2013 EEEEEEE € 274.95
28.12.2012 08.01.2013 FFFFFFF € 327.60
29.12.2012 09.01.2013 GGGGGG € 500.00
13.12.2012 12.01.2013 11111111 € 400.00
10.12.2012 14.01.2013 22222222 € 430.00
03.09.2012 15.01.2013 33333333 € 500.00
03.09.2012 15.02.2013 44444444 € 600.00
25.09.0212 18.01.2013 555555555 € 200.00
08.11.2012 20.02.2013 777777777 € 500.00
19.11.2012 20.03.2013 888888888 € 350.50
19.11.2012 20.03.2013 999999999 € 150.00
TOTAL 24.353.05
Thats cheques
As you can see now is sorter by valued date.
Lets say for example that I want to subtract all the cheques that valued in January. My step is to create a formula that subtract the cheques that value in January from the total amount. But if I decide to sort the cheques by Issued date the numbers changes in the cells that I previously select and the amount that I want to subtract change. How can I ''lock'' the numbers so the fuction always follow those numbers instead of the cells?
The real list is much longer by the way..
I think it's easy guys..
Anyway. Thanks in advance of any help...
Edit: I dont know why everythin turn out like this but you guys still can understand I guess...
Bookmarks