Forum Discussion
COUNTIF FUNCTION DOESN'T WORK IN TABLE FORMAT WITH ENTRY FORM
I am working on a spreadsheet to build a simple billing system for my son's business. He is not at all proficient with Excel. I am wanting to use the COUNTIF function to count the running occurrenc...
I believe that is a feature, and not an error. One of the main benefits of using tables is formulas that reference a table column will auto-update when the table is resized.
If, in another cell on your worksheet, you had =SUM(B2:B7) and then resized your table to add another row, then your sum formula would update to =SUM(B2:B8), which is a desirable feature. In your case, the last row of your table is referencing an entire column of the table and is getting updated as well (it doesn't appear to discriminate between updating formulas outside the table and within the table).
I would suggest using structured table references instead of A1 notation:
=COUNTIF(INDEX([Column A],1):[@[Column A]],[@[Column A]])