hello
im trying to sum the value for the different worksheets if they meet my criteria
-criteria is that, B7 is a drop down city name (i.e. NY, LA, Oklahoma City, 30+ cities etc)....so i need to be able to sum if the sales ppl (i.e. rep 1, rep 2 - worksheetname) are in a particular city....im failing miserable in my formula below, pls help, thx you very much!
=if(or(Rep1!,Rep2!,Rep3!,Rep4!,Rep5!,Rep6!,Rep7!,Rep8!,Rep9!,Rep10!,Rep11!,Rep12!,Rep13!,Rep14!,Rep15!,Rep16!,Rep17!,Rep18!,Rep19!,Rep20!"=Oklahoma City"),sum(Rep1!C16+Rep2!C16+Rep3!C16+Rep4!C16+Rep5!C16+Rep6!C16+Rep7!C16+Rep8!C16+Rep9!C16+Rep10!C16+Rep11!C16+Rep12!C16+Rep13!C16+Rep14!C16+Rep15!C16+Rep16!C16+Rep17!C16+Rep18!C16+Rep19!C16+Rep20!C16),"")
im trying to sum the value for the different worksheets if they meet my criteria
-criteria is that, B7 is a drop down city name (i.e. NY, LA, Oklahoma City, 30+ cities etc)....so i need to be able to sum if the sales ppl (i.e. rep 1, rep 2 - worksheetname) are in a particular city....im failing miserable in my formula below, pls help, thx you very much!
=if(or(Rep1!,Rep2!,Rep3!,Rep4!,Rep5!,Rep6!,Rep7!,Rep8!,Rep9!,Rep10!,Rep11!,Rep12!,Rep13!,Rep14!,Rep15!,Rep16!,Rep17!,Rep18!,Rep19!,Rep20!"=Oklahoma City"),sum(Rep1!C16+Rep2!C16+Rep3!C16+Rep4!C16+Rep5!C16+Rep6!C16+Rep7!C16+Rep8!C16+Rep9!C16+Rep10!C16+Rep11!C16+Rep12!C16+Rep13!C16+Rep14!C16+Rep15!C16+Rep16!C16+Rep17!C16+Rep18!C16+Rep19!C16+Rep20!C16),"")