HI guys! how is everyone. I have not been here for a while. I am curious to see if possibly anyone can help me with my predicament.
Ok so in one sheet I have dates going accross and I have line items...
1/1/2014 1/2/2014 1/3/2014
Bed 5 3 8
Cat
Dog 1 2 3
Rat
etc...
My question is I would like to call a week....
so say vlookup the week of 1/1/2014.... and see what are the total expenses for each item..
So in the end you will see a list of the things which are expensed and total expenses (for 7 days).
So in one cell you will see: and in other:
Bed 16
Dog 6
the other ones will be ignored..... hope this is possible.. brownie points for whomever can solve this...
appreciate it.
Ok so in one sheet I have dates going accross and I have line items...
1/1/2014 1/2/2014 1/3/2014
Bed 5 3 8
Cat
Dog 1 2 3
Rat
etc...
My question is I would like to call a week....
so say vlookup the week of 1/1/2014.... and see what are the total expenses for each item..
So in the end you will see a list of the things which are expensed and total expenses (for 7 days).
So in one cell you will see: and in other:
Bed 16
Dog 6
the other ones will be ignored..... hope this is possible.. brownie points for whomever can solve this...
appreciate it.