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...
You need to provide the static reference from the table's first record in order for the function you wrote to work with a table, as seen in the example below.
The first record in the table is in row 2, hence row 2 will be fixed in the first reference, which is $A$2 in the table below. The rest of the cell references will be dynamic and will not include the $ symbol. Copy this formula then to the entire column.
I hope it resolve your question