finding home wins and tally with column h

[stevecontracts]

hi guys
i am trying to work out how to compare home games and convert them in to results
i have attached spreadsheet for u to look at.

what i want to do is in cell n7 i want it to return liverpool wins as a result and a percentage

therefore i need it too look in column b and see where liverpool were at home and then in column h to see the result then tally these up.

so in the instance of the spreadsheet
liverpool were at home 21 times won 13 times drew 8 times and lost 0

can anyone help me out here

thanks in advance

[DonkeyOte]

Given use of XL2007

Please Login or Register  to view this content.

[stevecontracts]

hi donkeyote
thats great thank you very much
however
cell n9 counts total games rather than returning 0
is that what you intended and if so how do i get the answer 0 losses in another cell with regards to the previous cells?

thanks so much

[DonkeyOte]

N9 should be the COUNT of home appearances less prior calculations (wins/draws) - if you're not using N7:N8 to store these values you must adjust references in the SUM accordingly.

[stevecontracts]

its ok i sorted it thanks
i had these lines

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

therefore its only counting whats in column b because there is technically no answer in it??

i have transferred your lines to l7,l8 and l9

just for future reference is there a way of doing that formula which would take into account the text?

kind regards

[DonkeyOte]

...just for future reference is there a way of doing that formula which would take into account the text?

If you can't use prior results you would just use another COUNTIFS, ie:

Please Login or Register  to view this content.