Thats not possible because..

  • Thread starter Thread starter Poonam
  • Start date Start date
P

Poonam

When i enter USA in a cell 1000 cells look for USA and
then display the total minutes using sumproduct function.
That figure is displayed in a cell and i then manually
enter it in another cell next to USA.
When USA is changed to Canada those 1000 cells look
for "canada" and using sumproduct give me another figure.
Instead of manually entering values, i wanted to automate
it. Meaning, when USA is entered and a figure is
displayed, it goes to the corresponding cell next to USA.
i Can use =A2 to do that. When i enter Canada, =A2 gives
minutes of canada and not USA.
So IF USA, "TRUE" then the value, if FALSE, the cell
should have the value it used to have.
 
This is completely meaningless without a context. Please don't start a
new thread - instead *reply* in the old one.
 
Hi
your description is not very clear. Please try the following:
- post some example rows of your data (plain text - no attachment
please)
- specify exactly the cell ranges for your data
- specify exactly in what cell (with cell reference) you want to enter
a value
- specify your expected results an where you want to see them and what
should happen if you change the manual entered cell.

For me it sounded like you want to calculate a condtional valuefor your
data depending on a cell reference. So why not use something like
=SUMIF(A6:A1000,cell_with_country_B6:B1000)
 
It was creating a circular reference. I changed options
from TOOLS/CALCULATIONS. Now its working .
Thanks a lot.
 
Back
Top