COUNTIFS

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:

1. Put the COUNTIFS formula directly in the cell where you want the result.
2. 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.

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.