HELP! How do I get a total for columns sorted by account number on a spread sheet

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

Guest

Ok, I am not sure how else to explain this. On a spread sheet I will be entering account numbers and a balance due on different spots in the sheet. On a 2nd spread sheet I need it to find the specific account number and add up the total that customer owes. Can I do a total by account number by formula or will I have to do seperate spreadsheets for each person? If you can't tell I am lost.
 
Laurie,

Try something like

=SUMIF(Sheet1!A1:A100,"12345678",Sheet1!B1:B100)

where Sheet1!A1:A100 is the account number range, "123456768" is the account
number to check, Sheet1!B1:B100 are the amounts.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Laurie said:
Ok, I am not sure how else to explain this. On a spread sheet I will be
Click to expand...
entering account numbers and a balance due on different spots in the sheet.
On a 2nd spread sheet I need it to find the specific account number and add
up the total that customer owes. Can I do a total by account number by
formula or will I have to do seperate spreadsheets for each person? If you
can't tell I am lost.
 
Back
Top