Simple COUNTIF or Array Formula problem !

[tdt]

I have two arrays. D682 contains any one of the following values "A"
"B", "C", "S" or "AP". G6:G82 contains any one of the following value
"C", "N" or a number between 1 and 9.

I am attempting to simply count the number of rows that have the valu
"A" in the first column & the value "C" in the second column.

I have tried the following formulas, but neither seems to work?
{=COUNTIF(IF($D$6:$D$82="A",$G$6:$G$82),"C")}

and

=SUM(D682="A")*SUM(G6:G82="C")

Can anyone help please

 

[Norman Harker]

Hi tdt!

One way:

=SUMPRODUCT((D682="A")*(G6:G82="C"))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Paul]

I have two arrays. D682 contains any one of the following values "A",
"B", "C", "S" or "AP". G6:G82 contains any one of the following values
"C", "N" or a number between 1 and 9.

I am attempting to simply count the number of rows that have the value
"A" in the first column & the value "C" in the second column.

I have tried the following formulas, but neither seems to work?
{=COUNTIF(IF($D$6:$D$82="A",$G$6:$G$82),"C")}

and

=SUM(D682="A")*SUM(G6:G82="C")

Can anyone help please ?

=SUMPRODUCT((D682="A")*(G6:G82="C"))