Countif with Filter

[JW]

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

[Dave Hawley]

Hi JW

You will no doubt be shown various array formulas for this, I suggest strongly againts them!!

Try this better method:

Copy the heading of Column A to Cell G1, Copy the heading of column D to cell H1
In G2 put Y
In H2 put #N/A

In any cell put:

=DCOUNTA(A1:D5000,4,G1:H2)


I ahve some more advanced examples of these great function here:
http://www.ozgrid.com/download/default.htm

Under:
DFunctionsWithValidation.zip

[JW]

Thanks, that did it!