Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

If I understand your issue correctly, you need Sheet 1 Cell B to be equal to the value in sheet 2 conditional sum cell.

If that's true, then select cell B on the first sheet, then type "=" (no quotes), switch to the second sheet and click the cell you've used for the conditional sum. Then press <enter>. This will make Sheet 1 Cell B equal to the result in sheet 2, conditional sum, and Cell B will update whenever the value on sheet 2 changes.

As you do this, you will also see the results of your selection in the formula bar.

I hope this is a correct understanding of what you want to do.

Good luck!

If I understand your issue correctly, you need Sheet 1 Cell B to be equal to the value in sheet 2 conditional sum cell.

If that's true, then select cell B on the first sheet, then type "=" (no quotes), switch to the second sheet and click the cell you've used for the conditional sum. Then press <enter>. This will make Sheet 1 Cell B equal to the result in sheet 2, conditional sum, and Cell B will update whenever the value on sheet 2 changes.

As you do this, you will also see formula bar reflect the results of your selection in cell location you select. For example, assuming the conditional sum cell on sheet 2 is D13, then the formula bar. bar for Sheet 1 Cell B will read this:

='Sheet 2'.D13

I hope this is a correct understanding of what you want to do.

Good luck!