Difficulty with count if and data validation

Leave File - Play Document.pdf

Hi,

I am trying to create a formula (?sumifs) to show the data below

a) in cell B2 - it should count the number of AN blocks that Abigail has taken between the range of E2:L54 as with C2 counting the number of AT booked
b) in cell A1 - this is a list created from the data sheet - whenever you select the officer, I want it to highlight in the actual spreadsheet where the name appears. So that you are able to see relatively quickly where the leave has been booked for that officer.

Any help would be greatly appreciated. I have tried multiple ways, I know it's probably very basic, but no matter what I try and I can't get the answer I need.

Have a great day.
Mel

Hi,

I tried to attached the excel document, but it just shows a white line and doesn't allow attachment. I am currently on the work computer, I will try again when I'm at home.

Sorry
Mel

Just to clarify:

Worksheet Manager Students & Admin


I am trying to create a formula (?sumifs) to show the data below

a) in cell B2 - it should count the number of AN blocks that each employee has taken between the range of E2:I54 as with C2 counting the number of AT booked (data is entered manually throughout the year) I used to use DualSACount in old version
b) in cell A1 - this is a list created from the data sheet - whenever you select the officer, I want it to highlight in the actual spreadsheet where the name appears. So that you are able to see relatively quickly where the leave has been booked for that employee

Any help would be greatly appreciated. I have tried multiple ways, I know it's probably very basic, but no matter what I try and I can't get the answer I need.

Have a great day.
Mel