Hi you all,
Tried to upload my sample file but did not work.. sorry for that.. I hope my screenshot helps to imagine what i am looking for.
I hav a very big table like in the screenshor (more then 100 products an much more columns for every week.
What i want is this: if i select a day in cell AB3, then i want to see the totals (sum) in cell AB5 for that row and that day. the same formula for row 6 in AB6, row 7 in AB7,...
Hoping for a solution..
Thx
Tried to upload my sample file but did not work.. sorry for that.. I hope my screenshot helps to imagine what i am looking for.
I hav a very big table like in the screenshor (more then 100 products an much more columns for every week.
What i want is this: if i select a day in cell AB3, then i want to see the totals (sum) in cell AB5 for that row and that day. the same formula for row 6 in AB6, row 7 in AB7,...
Hoping for a solution..
Thx