On Oct 13, 2:14*pm, Mike H wrote:
Hi,

I built your table in A1 - F3

A * * * * * * * B * * * * * * * C * * * * * * * *D * * * * * E * * * * * * *
*F
Mon * * Tue * * Wed * * 06:00 * 06:10 * 06:20
y * * * y * * * y * * * PM * * *PM * * *PM
Y * * * * * * * Y * * * PM * * *XD * * *PM

and got the reuslt below with this formula
=SUMPRODUCT(($A2:$A8="y")*(D2:D8="PM"))
=SUMPRODUCT(($A2:$A8="y")*(D2:D8="XD"))
The 2 formula go in the cells marked F and drag right

* * * * 06:00 * 06:10 * 06:20
PM * * *F * * * 1 * * * 2
XD * * *F * * * 1 * * * 0

Mike



"MJKelly" wrote:
Thanks, but it's not having the desired effect.

Mon Tue Wed 06:00 06:10 06:20
Y * * *Y * Y * * PM * * PM * PM
Y * * * * * *Y * * PM * *XD * *PM

The above should result in a table displaying monday data as follows

* * * * 06:00 06:10 06:20
PM * 2 * * * *1 * * *2
XD * *0 * * * *1 * * *0

Hope this sheds some light?
Matt- Hide quoted text -

- Show quoted text -

Works a treat, thanks very much.

Kind regards,
Matt