| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Amount Based on Year
I'm trying to calculate the totals based on years and don't want to do a
basic sum in case I move things around, I want the totals to be specifically based on the year. I have appx 50 rows of data and need the formula to find all dates for the specific year and then sum those corresponding totals. Both columns are named as Amount and Finish_Date and E is formatted as a date, not text. I've tried several formulas and just can't get it to give me a total or the correct one. What am I missing? Thank you! Column D Column E Amount Finish Date $45,000,000 Mar-02 $50,000,000 May-05 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CALCULATE GST AMOUNT FROM AMOUNT IN OTHER CELL | Excel Worksheet Functions | |||
| Calculate a date based on period and year | Excel Worksheet Functions | |||
| how to calculate $1000/year at 5% for 25 years showing each year | Setting up and Configuration of Excel | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Threaded Mode
