I should know this, but it's escaping me right now, so..
I've got c13000 rows, with an IF function in Column D that I've filtered to show the #N/A results. From these, I want to count the number of rows where Column A shows Y. A Countif highlighting the filtered cells of column A picks up ALL of the Ys between the first and last filtered cells - how can I write this to show the total of Ys in Column A when Column D has #N/A?
TIA
I've got c13000 rows, with an IF function in Column D that I've filtered to show the #N/A results. From these, I want to count the number of rows where Column A shows Y. A Countif highlighting the filtered cells of column A picks up ALL of the Ys between the first and last filtered cells - how can I write this to show the total of Ys in Column A when Column D has #N/A?
TIA