COUNTIF calculations & Two-way Lookup
 

Hi, could someone please help with the following? I need to undertake a
COUNTIF calculations and a two-way lookup.

I need the user to select an Operation and Task Group and for Excel to
calculate various COUNTIF functions as follows:

I need Excel to lookup column E for all instances where the cells that
contain the text: "PERMANENT" or "FUTURE" or "TEMPORARY" or "FUTURE
DELETION" from the worksheet named: Data.

I also need Excel to lookup column U for all instances where the cells
that contain the text: "Y" from the worksheet named: Data.

If there are any matching records then I need excel to populate the
worksheet (in same workbook) named: Summary as follows:

in cell B8 - I need the COUNTIF function results for "PERMANENT".

in cell B9 - I need the COUNTIF function results for "FUTURE".

in cell B10 - I need the COUNTIF function results for "TEMPORARY".

in cell B11 - I need the COUNTIF function results for "FUTURE DELETION".

in cell B25 - I need the COUNTIF function results for "Y".

The actual COUNTIF calculations and two-way lookup needs to be performed
on worksheet named: Data. Column B contains the Operation data and
column C the Task group data and column E the Position type data and
column U the ROCL Replacement Authorised data.

The actual user input is performed on another worksheet (in the same
workbook) named: Summary. From this worksheet, the user selects the
Operation from the drop-down list at cell B2 and selects a Task Group
from the drop-down list in cell B4.

I want to use the COUNTIF function to calculate from $E$3:$E$65000 and
$U$3:$U$65000 on the worksheet named: Data.

Operations has a defined name = Operations!$A$2:$A$12.

Task Group has a defined name = Groups!$A$2:$A$29.

Any help with this would be greatly appreciated.

Kind regards,

Chris.


*** Sent via Developersdex http://www.developersdex.com ***