Excel Query

[markwales]

Morning all,

This has been driving me mad for the last hour !!!

Column D = PL, FL or ML
Column H = Lost or 1

I need 3 seperate calculations to count the number of 1's in column H, if Column D is PL, FL or ML

This is so I can calculate SR for the 3 lay systems.

HELP NEEDED!!!

Thanks in advance.

[Win2Win]

Why not have H,I,J for Lost or 1 for each system? And if not 1, place a '0' in the cell.

Just a simple task of adding them then.

[markwales]

Because that's too simple :D

[Win2Win]

I used to have columns everywhere before I learnt VBA....as long as you get the result, it doesn't matter what it looks like :)

[MarcusMel]

Three new columns of
Col X If(AND(D1="PL",H1=1),1,0)
Col Y If(AND(D1="FL",H1=1),1,0)
Col Z If(AND(D1="ML",H1=1),1,0)

[markwales]

Cheers Marcus - much appreciated. Worked a treat :D