I have a workbook that I am counting the number of times a number occurs in the column. I would like to know how to copy the formula or create a formula that will increase the criteria by one.
Example =COUNTIF(Table2,1)
=COUNTIF(Table2,2)
I would like to be able to have it do this when I copy the cell or use the crosshair to drag it down.
Bookmarks