Shayeebur
Member
Hi
This is shayeebur, u have posted one article upon vlookup the template file name was vlookup-on-multiple-conditions.xls in there u have taught me sales with below criteria that is salesman,region,month,product. The answer we can get by using 5 types of formulas that is sumifs, sumproduct,index,vlookup and usin sum array formulas.
My question u have mentioned home work that is what we need?-profit%? And total sales in Jan,feb,mar 2008 for lawrence and west. I tried a lot to get the answers by using all the above 5 types formulas for both the questions but i m not getring he correct answer so i request u to pls provide me both the answers for the above questions using 5 types of formulas pls.
This is shayeebur, u have posted one article upon vlookup the template file name was vlookup-on-multiple-conditions.xls in there u have taught me sales with below criteria that is salesman,region,month,product. The answer we can get by using 5 types of formulas that is sumifs, sumproduct,index,vlookup and usin sum array formulas.
My question u have mentioned home work that is what we need?-profit%? And total sales in Jan,feb,mar 2008 for lawrence and west. I tried a lot to get the answers by using all the above 5 types formulas for both the questions but i m not getring he correct answer so i request u to pls provide me both the answers for the above questions using 5 types of formulas pls.
