My "Charges" sheet has following labels:
A B C D
Item-Names Date Month(of Date) Amount
On "Summary" sheet, I use the formula below to sum all values for each item-name for certain periods only, by using boolean operators ex, <=6 (Jan to June), <5 (Jan to Apr), >3 (Apr to Current)
To make the formula more "dynamic" I placed a boolean operator (<=6) in cell address D2 and changed the formula using the INDIRECT function.
Needless to say, it did not work, keep getting #REF! errors no matter what I tried.
Thank you for taking the time to read my post, any suggestion will be much appreciated.
Bookmarks