I need help with a formula......
Posted by Mark on January 11, 2002 7:34 PM
I've set up a workbook for invoices. I bill jobs separately, each job has it's own job number. I have a formula that assigns each invoice a sequence number (for instance, job number 123's invoices are 123-1, 123-2, 123-3....you get the picture). I also have a macro that sends the job number , sequence number & the invoice total to a ledger for all jobs/all invoices on another sheet.
My question, how can I get the sum of all invoice totals into a cell on another sheet for each job?? any ideas?? Thanks