| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there a formula for quarterly expenses in Excel?
I'm trying to model an expense to come up on a quarterly basis. Help!!!
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is there a formula for quarterly expenses in Excel?
You don't give us too much to go on. This sums column B if the corresponding
date in column A is in Q1 Change =1 to =2 for Q2 wtc =SUM(IF((INT((MONTH(A1:A100)-1)/3)+1)=1,IF(A1:A100<"",B1:B100,0))) This is an array formula which must be entered with CTRL+Shift+Enter and NOT 'just enter. If you do it correctly then Excel will put curly brackets around 'the formula{}. You can't type these yourself. If you Edit the ranges 'then you must re-enter as An array Mike "Zach" wrote: I'm trying to model an expense to come up on a quarterly basis. Help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simplify formula using quarterly investment returns | Excel Worksheet Functions | |||
| how to increase manually expenses in a column in excel | New Users to Excel | |||
| Formula Help to Calculate Quarterly Results | Excel Discussion (Misc queries) | |||
| How do I graph a quarterly time-series in Excel? | Charts and Charting in Excel | |||
| sales, expenses and purchase ledger for excel | Excel Worksheet Functions | |||
Linear Mode
