Needa formula to find data from group of cells

in case you are sure what im tryingto do, i have attached the doc, you need to look at score book. Where ever AA appears betwenn B28 and Y91 i want to put the figure from the adjasent yellow cell into cell no, AQ29 ( runs from over AA ). Once that is done i will need to put runs from over BB into AQ30 then CC into AQ31, DD into AQ32 all the way down to VU which is AQ78.
The Double letters of AA, BB, CC etc will only appear once they have been inputted, so they could appear anywhere between rows 28 and 91.

Steve.................

A good sample workbook includes sample results, too.

What would the answers be for AA, BB, CC, DD?

Perhaps, I'd rather not guess. He can provide the answer to the four options requested and then it's exactly crystal clear where/what he wants.

Minty, please answer the question asked fully. I'd really like to help, but your reference to "yellow cells" should be clear but for some reason it isn't. Your sheet design is so unique it's not immediately clear where you're wanting the answers from.

Please provide "cell address" references for answers to the following... I imagine complete 4 example results would be enough to clear it up.


AA:
AQ29=6 (this comes from cell ???? in the example sheet)
AR29=? (this comes from cell ???? in the example sheet)

BB:
AQ30=? (this comes from cell ???? in the example sheet)
AQ30=? (this comes from cell ???? in the example sheet)

CC:
AQ31=? (this comes from cell ???? in the example sheet)
AQ31=? (this comes from cell ???? in the example sheet)

DD:
AQ32=? (this comes from cell ???? in the example sheet)
AQ32=? (this comes from cell ???? in the example sheet)

In AQ29, put this formula, then copy the cell downward:

=SUMIF($C$28:$X$91, $AP29, $B$28:$W$91)

In AR29, this formula:

=SUMIF($C$28:$X$91, $AP29, $B$33:$W$96)

Let me remind you your cricket terminology means nothing to me, so do not expect me to "interpret" any of your terms or meanings.

2 wickets in AA = 2 in AR30 (you get 2 from which cell?)
0 wickets in BB = 2 in AR31 (you get 0 from which cell?)
1 wicket in CC = 3 in AR32 (you get 1 from which cell?)
0 wicket in DD = 3 in AR33 (you get 0 from which cell?)
0 wicket in EE = 3 in AR34 (you get 0 from which cell?)

The running total part is easy. I don't know what a "wicket" is, so I'm expecting you to describe in Excel language what cell(s) you're looking at for those values.

UGH... after spending quite some time looking at this, I finally realized that you had already gathered the wickets per section in the lower left corner of each section. UGH.

So, try this in AR29 and copy down:

=SUMIF($C$28:$Y$91, $AP29, $B$33:$Y$96) + N($AR28)