Spreadsheet for Cricket

Before a moderator comes on and gives you a spanking, might I suggest you modify your post to include some details around the specific Excel issues you might be having? Sounds like you've got an interesting project on your hands, so there will be a number of people here with useful help for you when you ask a specific question.

thank you for your advice, i have also noticed it says im on excel 2003 , how do i change it to 2007

Click Quick Links / Edit Your Details.

Now if you have anything Excel related, there is a queue of anxious Excel gurus just salivating over helping out with your issues.

Would something like this be any good to you

Please Login or Register  to view this content.

where B3 to B5 for example is the range of cells.

Thanks Barry. I have already used that one to record wickets for precific bowlers stats, Im trying to use a formula that picks up W from the overs cells and transfers it to the wickets cell.

The COUNTIF should work equally well in this scenario.

Simply type =COUNTIF(

then highlight the cells you want to count the Ws in

then finish the formula with ,"W")

Message has been change to read info needed.

I have attached a sheet, hope it is something like you are after. I have assumed that each over will be in a line in its own box of 18 cells. I had to rename the overs as AA instead of A or the lookup would not work as you are using M and W already.

your being very helpfull barry, but i dont think im explaining myself properly. how can i copy part of my spread sheet and attach it to a message to you.

Steve...

At the bottom of this page, click 'Go Advanced' then click the little paper clip on the next page to attach a file.

i have attached a copy of what ive prepared so far,
im trying to find a way of asking to look for AA ( anywhere between cells B2 and Y16 )
and then take the figure in the appropriate yellow filled cell next to it ( ie AA is in C2, yellow box is B2 = 6)
What ever the figure is in B2(6) im trying to put it into AQ3

any help would be appreciated

There is most likely a better way to do this but I think I got it going in the end. The lookup and index would not work on multiple lines so I have nested the if statements on errors.
Sorry it took so long.

Barry, You star. Works brilliantly on the sample i sent you , BUT, my document has more bowlers rows so all the cell no,s are not working. my no, is you want to call me is 01865-400958 and maybe we could sort it over the phone. if not, i will have to sent the complete doc. with all its correct cell no,s to work with.

steve.....

If you want to post another sheet i will have a look at it but the last version was beyond me really, you can see the formula is a bit messy even though it works. I'm sure there are ways of doing anything its just finding the way.

i have attached the cricket (2) version. When you open it, the sheet im working on is called score book and not sheet two which is the one you have seen.

steve....................

Minty sorry this took so long but I kept checking every couple of days to see if you had posted the worksheet but I did not see it as I did not realise there was a second page.
Any way I think this sheet should work ok but I had to do it in vba.