Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Dear All
I have a sheet where i am trying to set up for expenses In first column i have the description and then there are 12 columns, one for each month In another sheet i am trying to make a consolidation of expenses. I have in cell A1 the month There is any possibility to bring in column B the sum of expenses from the other sheet based on the number of the month? For example if the month is September (9) to add the column b to j if month goes to October (10) then to add column from b to k Any ideas ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy a formula down a set number of times | Excel Worksheet Functions | |||
Creating a certain number of entries based on a number in a cell | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions |