Hello (Excel 2016)
I have a table with 2 columns table[dateOpen] and table[dateClosed].
I would like to count the number of times dateOpen and dateClosed are equal just referencing the column name.
=COUNTIF(table[dateOpen],"="&table[dateClosed]) returns #VALUE!
Bookmarks