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