Amit Punia
Member
Kindly find the attached file for total cost of a project. It is divided into 2 phases.
Need an array formula or any other formula(maybe SUMIFS) in yellow cells only (Cashflow Tab). The data should be fetched from "Sheet2" tab. The data should be fetched based on 3 conditions -
1st Condition - Should fetch the data on the basis of cost centres(like "FOUNDATION", "BASEMENT FLOOR WITH PODIUM", "GROUND FLOOR TO THIRD FLOOR" etc.)
2nd Condition - Should fetch the data on the basis of Phase (Phase I & Phase II).
3rd Condition - Should fetch the data on the basis of quarters, So first quarter is of 4 months and all the quarters after that are of 3 months. So based on the months data, the output should sum up quarter wise.
2-3 cells are already completed manually using SUM formula.
Need a formula which can be copied in the whole yellow region and which takes into consideration all the three conditions i.e. Cost centres, Phases and sum of data based on quarters.
Need an array formula or any other formula(maybe SUMIFS) in yellow cells only (Cashflow Tab). The data should be fetched from "Sheet2" tab. The data should be fetched based on 3 conditions -
1st Condition - Should fetch the data on the basis of cost centres(like "FOUNDATION", "BASEMENT FLOOR WITH PODIUM", "GROUND FLOOR TO THIRD FLOOR" etc.)
2nd Condition - Should fetch the data on the basis of Phase (Phase I & Phase II).
3rd Condition - Should fetch the data on the basis of quarters, So first quarter is of 4 months and all the quarters after that are of 3 months. So based on the months data, the output should sum up quarter wise.
2-3 cells are already completed manually using SUM formula.
Need a formula which can be copied in the whole yellow region and which takes into consideration all the three conditions i.e. Cost centres, Phases and sum of data based on quarters.
