Hoping someone can assist. Im looking for either a formula or code that will do the following:
Once a position is selected in Developers tab cell B3, a formula or code will sum the totals for various stages from the Open Position Data tab and place those totals in the appropriate cells on the Developer tab (See Example File).
If Quaterback is in cell B3 (Developers tab), if would show 1 in cell H13 because there is only one row listed in the Open Position Data tab showing a Quarterback who has a status of New- To Be Evaluated and the applicant is external. The code or formula will need to take into consideration if the position is internal or external by looking at row F of the Open Position Data tab.
A second example would be the position of Waterboy which would show a 2 in cell K19 because there are two applicants, listed as waterboy, with a status of Pre-Screen - Left a Message, that are both External.
Any assistance would be greatly appreciated!!!!!