Forum Discussion
COUNTIFS
Can I change the output of a COUNTIFS function to a different cell? I would like it to calculate in one cell and output the result to another cell for easier copy and paste procedures.
short answer is No.
A formula will always and can only produce an out that is displayed in the cell it is located.
BUT with array formulas that 'spill' into adjacent cell you can sort of do this. You can't designate it to go to any other cell but you can make it show in an adjacent cell. For example:
=HSTACK("", COUNTIFS( ....) )
This will show blank ("") in the current cell and the output of that COUNTIFS will be show in the cell next to the right.
I don't understand why you want this because if you copy the cell it will copy the resulting value in either case.
Maybe if you could explain more about the issue or challenge you are having a better or more concise solution could be suggested.