sales record and receipts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to keep a track of the sales and see if i get the payment. Payment is
received according to the invoice numbers. Eg invoice no 1 dated 1/1/2005.
payment will be expected after 45 days, say 16/2/2005. so now when i feed in
the invoice number i want it to find in the whole list of various invoice
numbers the particular invoice no, tally the value, if not true then mention
the +/- value.. so how do i do that
 
Take a look at the SUMIF() function. For the plus / minus value, you
could return (in a different cell) the amount expected, and subtract
the expected amount from the amount received.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Apply Pament to invoices in form 0
making a sum total 2
Drop down lists and autofill 3
Workbook for entering POs and matching and paying invoices 2
linking cells again :-( 7
Database design many to many relationships 4
Averaging many non-contiguous cells if they are blank 1
Select and updates records based on previous record selections 2

Back
Top