Can we get count or sum vale in a cell for cells we have selected.

[RAmraj R]

Can we get count or sum vale in a cell for cells we have selected.
Here countif work only for the range which is selected, but i want not to fix the range as range keeps varying as & when i keep selecting the different range.
For better understanding of question, i want status bar function in a particular cell, say for example A1

 

[Joe4]

Welcome to the Board!

You are not going to be able to do with just regular Excel functions.
This is will require some VBA. Are you open to that?

If so, please provide the necessary details, such as:
- what cell you would like the result to be in (cell A1?)
- if you want a COUNTIF, what criteria exactly do you want to apply to the formula?