Auto calculating cells based on criterie

[sdts]

Hi guys

I have attached spreadsheet to make things easier
in cell B7 i wish data to be displayed as Played(Number), Won(Number), Drawn(Number), Lost(Number

Played will be based on how many "y" are between cells C7 & AV7
Won will be based on how many "y" are between cells C7 & AV7 but also have "Won" between cells C3 & AV3
Drawn will be based on how many "y" are between cells C7 & AV7 but also have "Drew" between cells C3 & AV3
Lost will be based on how many "y" are between cells C7 & AV7 but also have "Lost" between cells C3 & AV3

I would sincerely appreciate any help regarding this
Thank you

[Estevaoba]

Try this:

Please Login or Register  to view this content.

Good luck!

[sdts]

Hi Estevaoba

thank you for your reply it works well
however i would like it to read P1, W0, D0, L1

thank you so far

[Estevaoba]

OK, then this will do it:

Please Login or Register  to view this content.

[sdts]

thank you Estavaoba
superb
much appreciated