Help managing data across sheets

Hi,

I am a bit of a novice when it comes to Excel, and need some help modifying a spreadsheet template which I am working on.

What I need to do :
* The tab "detailed RAID" contains a long list of items. One of the columns in there is column E, "Release"
* The options for release are "July 1st Release, August 18th Release and September 27th release" - selected from a dropdown driven by the data in sheet "ADMIN"

So far, so good.

What I need, is to amend the formulae in the table, starting cell B87 on each of the individual tabs called ""July 1st Release, August 18th Release and September 27th release" - so that the count only applies if in the RAID tab, the value selected matches the name - so for example, if a row is added in the RAID tab, and the release value is selected as "July 1st Release" then this should update the count in the "JUly 1st Release" tab accordingly.

At the moment, I believe the formulae in that table simply counts the total - regardless of the value entered into the release field.

Similarly, I have the same problem with the table in cell K86 - this should match only for the release in the title of the sheet.


I hope someone can help me, as I said before, this is a template only which I am trying to tailor to my needs.

Many thanks for your help.

Chris.