#1
|
|||
|
|||
need excel formula using if function
need excel formula using if function i have a range of date and amount spend. i need a formula which can auto calculate the current month spendings and auto refresh after every month. |
#2
|
|||
|
|||
|
#3
|
||||
|
||||
Try a Pivot Table
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
Easiest way is to use a helper column. Attached is an example with different possible solutions:
You can define dynamic named range (dnDateMonth in my example), and use this to calculate the helper column DateMonth; Or you can calculate month number directly in helper column - like in alternate helper column DateMonth2 - instead; You can calculate current month like in named cell nCurrMonth, and use nCurrMonth in formula to calculate the amount for current month; You can select the month using Data Validation List for cell nMonth, and use nMonth in formula to calculate the amount for selected month. You need a helper sheet (which can be hidden) to create a list of available months which is based on your date amount entries. |
#5
|
|||
|
|||
Admins! Is it possible to delete the redundant post (this one - without attachment)
Easiest way is to use a helper column. Attached is an example with different possible solutions: You can define dynamic named range (dnDateMonth in my example), and use this to calculate the helper column DateMonth; Or you can calculate month number directly in helper column - like in alternate helper column DateMonth2; You can calculate current month like in named cell nCurrMonth, and use nCurrMonth in formula to calculate the amount for current month; You can select the month using Data Validation List for cell nMonth, and use nMonth in formula to calculate the amount for selected month. You need a helper sheet (which can be hidden) to create a list of available months which is based on your date amount entries. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SubTotal function counts the blank cells with formula | LearnerExcel | Excel | 3 | 12-29-2019 04:54 AM |
Formula/function to return column names for matching values | GiJoe81 | Excel | 1 | 06-27-2015 12:13 AM |
Need VBA Function in Word table formula | nschroeder | Word VBA | 6 | 05-13-2013 03:58 PM |
Excel Function | co-lay | Excel | 3 | 02-13-2012 03:46 PM |
Would appreciate help with formula or function | e_a_g_l_e_p_i | Excel | 1 | 03-12-2011 08:53 PM |