Generating a cell reference

G

GeeBee

I cannot find the solution to my question anwhere.

If I enter the letter A in cell b3, enter the number 10 in cell d3, enter
the letter A in cell b5, and enter the number 20 in cell d5, then how do I
create cell references from these entrys that can be used in formulas, such
as sum(a10:a20)? I hope this makes sense, I really would like to accomplish
this. Thanks for any advice and assistance.

Glen
 
R

RagDyer

Try this:

=SUM(INDIRECT(B3&D3&":"&B3&D5))

You did say "A" was in B3 *and* B5, so I used B3 twice,
since you wanted: <<"sum(a10:a20)">>

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I cannot find the solution to my question anwhere.

If I enter the letter A in cell b3, enter the number 10 in cell d3, enter
the letter A in cell b5, and enter the number 20 in cell d5, then how do I
create cell references from these entrys that can be used in formulas, such
as sum(a10:a20)? I hope this makes sense, I really would like to accomplish
this. Thanks for any advice and assistance.

Glen
 
R

Robert Christie

Hi GeeBee
Is this what you are after; =SUMIF(B3:B5,"A",D3:D5)
answer = 30

HTH
Bob C
 
Top