Hi !
I am looking for the solution for very simple problem but not able to find the reply any where.
I have a data where Column a and B have the details about particular and c onwards for next 7 columns have data of the particular type.
Column a is common so no need to touch . Column B has different type of calls based on skill set.
C onwards we have number of calls ansered / Calls abandoned etc ..
on other sheet we have skill sets groups which are written in column a and b . All skill sets of sheet 1 are there in Column a of sheet2. and these are diveded in four groups in column B.
Now on sheet 3 I want to have the sum of Sheet1 cloumn c to I, based on the four groups using the formula.
I can use the sumif and index or Vlookup and Index , but not able to define that withhout making intermediate sheet , if i an use some formula to have Sheet2 column B , group as reference .
I am looking for the solution for very simple problem but not able to find the reply any where.
I have a data where Column a and B have the details about particular and c onwards for next 7 columns have data of the particular type.
Column a is common so no need to touch . Column B has different type of calls based on skill set.
C onwards we have number of calls ansered / Calls abandoned etc ..
on other sheet we have skill sets groups which are written in column a and b . All skill sets of sheet 1 are there in Column a of sheet2. and these are diveded in four groups in column B.
Now on sheet 3 I want to have the sum of Sheet1 cloumn c to I, based on the four groups using the formula.
I can use the sumif and index or Vlookup and Index , but not able to define that withhout making intermediate sheet , if i an use some formula to have Sheet2 column B , group as reference .