how to relate sheets sum (complicated)
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
Hi sanji_thecook
Welcome to the forum
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
Doing this will ensure you get the result you need!
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
VBA for smarties - snb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks