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.
No. A formula can only return its result in the cell where the formula is entered.
So a COUNTIFS formula in A1 cannot directly output its result into B1.
Options:
- Put the COUNTIFS formula directly in the cell where you want the result.
- Or keep the formula in one cell and link another cell to it:
=B1
For example, if the COUNTIFS result is in B1, put this in C1:
=B1
If you need the result copied elsewhere automatically as a fixed value, that would require VBA or manual copy > paste values.