[mso] Re: Excel Formula Question
- From: "Jenny Johnson" <jj1@xxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sat, 2 Sep 2006 00:44:04 -0400
I was able to figure out one way to do it. I made one grid where the
requisitions are entered and another grid with each account listed in a
column for calculation. I used a pretty simple formula in the tracking grid
=if(c5=$m$1, G5,"") Where c5 is the account name where the requisition is
posted and $m$1 is a column heading with the same account name and G5 is the
amount for that requisition. When the requisition is posted, the amount
goes to the correct column where I just have the formula =M3-SUM(M5:M141)
where M3 is the budgeted amount for that account and then any amounts that
go to that column will be subtracted.
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Jenny Johnson
Sent: Friday, September 01, 2006 10:24 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Excel Formula Question
I would like to keep a running total of various budget line items(accounts)
as requisitions are processed. I have created a spreadsheet that has
columns of Date, Requisition #, Vendor, Amount, Account Name, Account
Number, etc. For Account Name, I have a drop down list and when users
choose the name, the number will fill in. I have another sheet with a
master budget.
So if one account A starts with $1000 and account B has $500 and I have a
requisition from Account A, I think I can write a formula that would find
the account number and the budgeted amount and subtract the first
requisition. But later when I write another requisition, how do I make it
look at all the requisitions that have been written for Account A to get the
running remaining balance?
Thanks for any help you can offer. Please let me know if I can clarify my
question.
Thanks,
Jenny
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top. This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
