Display reference value

[vtisix]

If cell A1 contains "Red" and A2 contains "Apple", I have the following
formula:

=sumif(Fruits,"&A1&" "&A2&",Amount)

Now, I want to find a quick way to get the formula to actually display
the value, i.e.

=sumif(Fruits,"Red Apple", Amount)

I thought I saw somethere that there is a shortcut to do this?

Any thoughts?

Thanks,

VT

 

[firefytr]

Hi,

Are you talking about Concatenate'ing A1 and A2 together, the
referencing that cell? Guess I'm a little lost here. If in B1 yo
put...

=A1&" "&A2

and in B2 you put...

=SUM(Fruits,B1,Amount)

(I'm assuming Fruits and Amount are both named ranges?) If not, coul
you elaborate

 

[vtisix]

Simply, instead of seeing this:

=sumif(Fruits,"&A1&" "&A2&",Amount) on the formula bar, I want to see this:

=sumif(Fruits,"Red Apple", Amount)

A1 has Red and A2 has Apple.

I believe there is a function in excel to actually display the output of
the referenced cells.

If you go to Tools > Formula Auditing > Evaluate Formula and click next
a few times, you will see the referenced value of "&A1&" "&A2&" being
evaluated to "Red Apple" before the entire formula is solved.

Maybe I'm just seeing things.

 

[Frank Kabel]

Hi
try the following:
- select the relevant part of your formula in the formula
bar
- hit F9 to evaluate this formula part

 

[vtisix]

That works, thanks. Is there a way to do that for hundreds of cells?