Forum

i know i just came up with that very quick example after the example workbook.... it works a treat thank you so very much for your time and pa...

Thank you for your reply Yes trying to count that every time a player gets a yellow playing against a team at home that it counts it and accumulat...

is it possibe to add column "N" to this formula =SUMPRODUCT(--(B$2:B2&E$2:E2=B2&E2)*(G2="YC"),J$2:J2) "N" would either be home maybe to someth...

that is absolutely fantastic but unfortunately its not what i need as the its the formula that i require because the work book example i supplied is j...

Yes fantastic until i added the home / away column

here is a sample workbook i hope it help TIA for all help so far Pa