N
nevi
Hello All,
What I currently have is:
=SUMPRODUCT(('Daily Tracker'!C4:C115="Aircard - Connectivit
Issue")*('Daily Tracker'!B4:B115={"Ait-Hamou, Achour","Antoine
Louis-Bernard","Brassard, Yanik","Dawson, Ronald","De Gonzague
Gilles","Gavilan, Carlos","Hachey, Anthony","Maheux-Anctil
Pierre","Nguyen, Minh Trun","Ortega, Orlando","Salazar, Ramon","Smadja
Yves","St. Pierre, Luc","Thomas, Steve","Troufanov, Alexandre"}))
The idea here is that it is counting how many times "Aircard
Connectivity Issue" is selected in C4:C115 on the Daily Tracker Sheet
but only if the corosponding name in B4:B115 matches one of the name
listed.
Now, all of those names listed there in quotes are also listed in cell
D520 of the same sheet. Currently, anytime I need to change the name
for this(which is ofter, unfortunatley) I change this whole list. I'
like to find a way to tell it to compare against the list of names i
D535(leaves room for the list to grow).
Any ideas
What I currently have is:
=SUMPRODUCT(('Daily Tracker'!C4:C115="Aircard - Connectivit
Issue")*('Daily Tracker'!B4:B115={"Ait-Hamou, Achour","Antoine
Louis-Bernard","Brassard, Yanik","Dawson, Ronald","De Gonzague
Gilles","Gavilan, Carlos","Hachey, Anthony","Maheux-Anctil
Pierre","Nguyen, Minh Trun","Ortega, Orlando","Salazar, Ramon","Smadja
Yves","St. Pierre, Luc","Thomas, Steve","Troufanov, Alexandre"}))
The idea here is that it is counting how many times "Aircard
Connectivity Issue" is selected in C4:C115 on the Daily Tracker Sheet
but only if the corosponding name in B4:B115 matches one of the name
listed.
Now, all of those names listed there in quotes are also listed in cell
D520 of the same sheet. Currently, anytime I need to change the name
for this(which is ofter, unfortunatley) I change this whole list. I'
like to find a way to tell it to compare against the list of names i
D535(leaves room for the list to grow).
Any ideas