Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make a custom formula for Excel?
I use excel for my checkbook register and I have a budget that "runs" beside
it to keep a monthly track of everything in the same worksheet. I want to write a formula that would take, for instance, my gasoline purchases from the checkbook, then place and continue to add up the monthly gasoline purchases in the budget column. I know very little about formulas. Right now, I manually add up all the rows that say Gas for the month and place them into the budget line. I appreciate your assistance. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make a custom formula for Excel?
There are a variety of ways to create cums for budgets, depending on how you
have your workbook setup. From your example, I would suggest the SUMIF function. Excel's help can provide more insight, but something like =SUMIF(A:A,"Gas",B:B) Would give you a sum of all numbers in the B column where you had the word "Gas" in the A column. I'd also suggest looking up in the help file about freezing cells (so you can always see budget line). -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "infamouswb" wrote: I use excel for my checkbook register and I have a budget that "runs" beside it to keep a monthly track of everything in the same worksheet. I want to write a formula that would take, for instance, my gasoline purchases from the checkbook, then place and continue to add up the monthly gasoline purchases in the budget column. I know very little about formulas. Right now, I manually add up all the rows that say Gas for the month and place them into the budget line. I appreciate your assistance. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make a custom formula for Excel?
Modify to suit. Assumes valid dates in col A, categories like gas in col c
and the amounts in d =SUMPRODUCT((MONTH(A7:A500)=ROW(A1))*(C7:C500="gas ")*D7:D500) I suggest using a credit card with a 1% or better rebate. -- Don Guillett Microsoft MVP Excel SalesAid Software "infamouswb" wrote in message ... I use excel for my checkbook register and I have a budget that "runs" beside it to keep a monthly track of everything in the same worksheet. I want to write a formula that would take, for instance, my gasoline purchases from the checkbook, then place and continue to add up the monthly gasoline purchases in the budget column. I know very little about formulas. Right now, I manually add up all the rows that say Gas for the month and place them into the budget line. I appreciate your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make custom buttons for macros on quick access bar excel 2007 | Excel Discussion (Misc queries) | |||
how do i make Excel 'remember' the custom formatting? | Setting up and Configuration of Excel | |||
How can i make a custom templet in excel? | Excel Discussion (Misc queries) | |||
make custom header and footer in excel apply to all worksheets | Excel Discussion (Misc queries) | |||
Can I make a custom button in Excel for the Group feature? | Excel Worksheet Functions |