Help with a simple problem

pix_jnr

New Member
Joined
Oct 12, 2005
Messages
13
Hey guys

i want to do the following.

Say i need to sum A5:A7. hence i could do = sum(A5:A7)

but instead say B1 and C1 contain the numbers 5 and 7

can you do =sum(A(value(B1)):(A(value(C1)) to produce the same result

this would be good help.


cheers, pix
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,059
Office Version
  1. 365
Platform
  1. Windows

pix_jnr

New Member
Joined
Oct 12, 2005
Messages
13
??? i tried using the =indirect formula but how do i incorporate this with =sum(....)

please help
 

Watch MrExcel Video

Forum statistics

Threads
1,118,521
Messages
5,572,628
Members
412,475
Latest member
JaredNAU
Top