Harry_1989
New Member
- Joined
- Sep 7, 2015
- Messages
- 28
HI All,
I am stuck in below while combining count ifs function.
I have 7 count ifs function which are linked to 7 different variable, my target is when user select different dropdown from 7 variable availibles, data should refresh.
Example of dropdown providing just 3 for example
1) Location (Mumbai and New-york)
2) Process (HR, Finance, Marketing)
3) Gender ( Male, Female)
Now i need this data for creating funnel:
1) Footfall : Created countifs formula for locationwise separate, proceesswise separte and genderwise separate with no conditions (Wanted to combine all 3countifs function when user select location, process or gender, count will change)
2) HR select:Created countifs formula for locationwise separate, proceesswise separte and genderwise separate with Hr select status in Column S (Wanted to combine all 3countifs function when user select location, process or gender, count will change for HR select)
3) Assessment Select: Created countifs formula for locationwise separate, proceesswise separte and genderwise separate with assessment Select status in Column T (Wanted to combine all 3countifs function when user select location, process or gender, count will change for assessment select)
4)Ops Select: Created countifs formula for locationwise separate, proceesswise separte and genderwise separetly with Ops Select status in Column U (Wanted to combine all 3countifs function when user select location, process or gender, count will change for ops select)
5) Final Select: Created countifs formula for locationwise separate, proceesswise separte and genderwise separetly with final select in column V Wanted to combine all 3countifs function when user select location, process or gender, count will change for Final select)
I have created 3 count ifs for each stage, wanted to combine or else how i combine below formula.
=IF($L$3="All",COUNTIF(DataSheet!$BH$2:$BH$100002,"<>"),COUNTIF(DataSheet!$BH$2:$BH$100002,$L$3))
=IF($L$4="All",COUNTIF(DataSheet!$E$2:$E$100002,"<>"),COUNTIF(DataSheet!$E$2:$E$100002,$L$4))
=IF($L$5="All",COUNTIF(DataSheet!$Z$2:$Z$100002,"<>"),COUNTIF(DataSheet!$Z$2:$Z$100002,$L$5))
L is dropdown cell.
Thanks
Harry Singh
I am stuck in below while combining count ifs function.
I have 7 count ifs function which are linked to 7 different variable, my target is when user select different dropdown from 7 variable availibles, data should refresh.
Example of dropdown providing just 3 for example
1) Location (Mumbai and New-york)
2) Process (HR, Finance, Marketing)
3) Gender ( Male, Female)
Now i need this data for creating funnel:
1) Footfall : Created countifs formula for locationwise separate, proceesswise separte and genderwise separate with no conditions (Wanted to combine all 3countifs function when user select location, process or gender, count will change)
2) HR select:Created countifs formula for locationwise separate, proceesswise separte and genderwise separate with Hr select status in Column S (Wanted to combine all 3countifs function when user select location, process or gender, count will change for HR select)
3) Assessment Select: Created countifs formula for locationwise separate, proceesswise separte and genderwise separate with assessment Select status in Column T (Wanted to combine all 3countifs function when user select location, process or gender, count will change for assessment select)
4)Ops Select: Created countifs formula for locationwise separate, proceesswise separte and genderwise separetly with Ops Select status in Column U (Wanted to combine all 3countifs function when user select location, process or gender, count will change for ops select)
5) Final Select: Created countifs formula for locationwise separate, proceesswise separte and genderwise separetly with final select in column V Wanted to combine all 3countifs function when user select location, process or gender, count will change for Final select)
I have created 3 count ifs for each stage, wanted to combine or else how i combine below formula.
=IF($L$3="All",COUNTIF(DataSheet!$BH$2:$BH$100002,"<>"),COUNTIF(DataSheet!$BH$2:$BH$100002,$L$3))
=IF($L$4="All",COUNTIF(DataSheet!$E$2:$E$100002,"<>"),COUNTIF(DataSheet!$E$2:$E$100002,$L$4))
=IF($L$5="All",COUNTIF(DataSheet!$Z$2:$Z$100002,"<>"),COUNTIF(DataSheet!$Z$2:$Z$100002,$L$5))
L is dropdown cell.
Thanks
Harry Singh