Hi,
If your Details is column B and Approved/Not is column D use the below
formula in the first row and just copy it down and you will get what you need.
=SUMPRODUCT(--(B1:$B$1=B1),--(D1:$D$1="Approved"))
--
If this helps, please click "Yes"
<<<<<<<<<<<


"suek" wrote:

Hello!
I have items coming to me from various areas, which get recorded in a
spreadsheet and given the next number in a list. A manager reviews the item,
and then approves or otherwise
So the spreadsheet looks like this:
Request number; Area; Details ;Approved/Not Approved
1 - Green - DaDa - Approved
2 - Green - DaDa - Approved
3 - Red - DaDa - Approved
4 - Red - DaDa - Not Approved
5 - Green - DaDa - Approved
6 - Red - DaDa - Approved

I want to put in a column that automatically puts in the approval number for
each area. So in this example, request 5 would be approval number 3 for the
Green area, and request 6 would be approval number 2 for the red area.
I have been trying to do an if statement where if E= "approved", but cannot
get the value if true statement to do a count of the number of times there
has already been an approved for a particular area.

Would appreciate some assistance