Formula Help

[Boenerge]

Hi,
I have a data sheet that contains a list of different departments in one
cloumn (column B). In the rows I have recorded if the area has met a target
with a "Y", if they haven't it is left blank.

I want to set up a formula in a cell to look for a certain department in
coumn B e.g. 1a, then for the formula to look across to see if the criteria
has been met

Column
B C D E F G H
I
ROW 4 1a PGI Y Y
5 12 DDH Y Y Y

6 1a PGI Y Y Y

So in this example I would want the formula to look up "1a" in column B and
then look across both rows to criteria F and return the value of 2.

Thanks in advance
Jason Alcorn

 

[Per Jessen]

Hi

Try this formula:

=Sumproduct(--(B4:B6=1a),--(F4:F6="Y"))

Regards,
Per

 

[J Alcorn]

Thanks, works a treat.

Hi

Try this formula:

=Sumproduct(--(B4:B6=1a),--(F4:F6="Y"))

Regards,
Per