hi,
If there's anyone can help me,i need a solution is vlookup command can be used to relate a total sum formula?
for example : (this is the total expenses of my routine day)
day 1
books rate quantity total price
mineral water rate quantity total price
pen rate quantity total price
day 2
pencils rate quantity total price
sharpener rate quantity total price
and a few days continue with same@different stuff bought
my solution will be on day 2 i also include books,mineral water and pen but for the quantity i put it 0..so at the total sum sheets, the 1st rows will be books..is there any smarter solution to avoid typing the stuff but doesn't effect the total sum??
thanks
Bookmarks