Why am I having trouble Referencing References

[Quickleaf]

Okay, so, I'm curious friends. This is my first post here, so I apologize if it's already been asked.

When I'm working in Excel one of the things I've been trying to do is have my formulas spit out their products, and then use those products as a component in another formula.

For example, if I use a =Sum(A1:A2) in cell A3 and then I try and do =Sum(A3:B2) in Cell C1 it kicks back an invalid cell reference because the cell A3 is a derived value. Is this something I'm doing wrong, or is this just some weird hiccup in Excel.

Thanks!

 

[gaz_chops]

Welcome to the forum.

Try in cell C1
=A3+B2

 

[TheRedCardinal]

I think it's probably more because your range doesn't make sense?

You need =A3+B2 rather than a sum of a range, or even =Sum (A3,B2).

Welcome to the forum!

 

[Fluff]

If you want to sum A3 & B2 then you need to have a comma between them, otherwise it is trying to sum A2,B2,A3 & B3.
And if you enter =sum(A3:B2) it will switch to =sum(A2:B3) as the range will always start with the top left cell.

 

[TheRedCardinal]

If you want to sum A3 & B2 then you need to have a comma between them, otherwise it is trying to sum A2,B2,A3 & B3.

I just tried this on Excel for my own curiosity.

When I entered =Sum (A3:B2) Excel changed it to A2:B3....

Is this a feature?

 

[Fluff]

See post#4

 

[TheRedCardinal]

See post#4

Please tell me that was an edit rather than me being silly? ?

 

[gaz_chops]

Pretty sure it was an edit