a simple SUM()

[Peter100]

I want to do a simple SUM(A1:A10)

but I want to make the A1 part of it variable by entering the value in say cell D1.

In other words the SUM would read
SUM("content of D1:A10)

Any ideas

 

[NBVC]

Are you really looking for something like:

=SUMIF(A1:A10,D1)

 

[Joe4]

Try:

=SUM(INDIRECT(D1 & ":A10"))

 

[Aladin Akyurek]

I want to do a simple SUM(A1:A10)

but I want to make the A1 part of it variable by entering the value in say cell D1.

In other words the SUM would read
SUM("content of D1:A10)

Any ideas

Do you mean?...

=SUM(INDEX(A:A,D1):A10)

 

[plettieri]

Hi:

Maybe a sample of your data and expected results might be helpful...

plettieri

 

[Peter100]

Cheers Jmiskey that did it. thank you