COUNTIF issue resolution

[Backroomgeeza]

Hi

I was wondering if you could help me with a count if formula.

I am trying to create a formula in cell B3 of the summary sheet to count the number of J's in column E on the detail sheet, if the value of the corresponding A cell's value is the same as the cell A3 in the summary sheet. The range is A1:E22 in the detail sheet, the criteria is cell A3 in the summary sheet (i think). I am getting a 'too many arguments' error when i try...

Any help greatly appreciated.

[Fotis1991]

Hi

...I am getting a 'too many arguments' error when i try...

Try what?

I am not sure if i am following you, but pls, give a try to this in B3 of your Summary Sheet.

=SUMPRODUCT((detail!$A$2:$A$22=A3)*(detail!$E$2:$E$22="j"))

Is this, what are you looking for??

[Cutter]

Try
=COUNTIFS(detail!$E$2:$E$22,"J",detail!$A$2:$A$22,summary!A3)

[Backroomgeeza]

Hi



Try what?

I am not sure if i am following you, but pls, give a try to this in B3 of your Summary Sheet.

=SUMPRODUCT((detail!$A$2:$A$22=A3)*(detail!$E$2:$E$22="j"))

Is this, what are you looking for??

once again many thanks Fotis

[Fotis1991]

You are welcome.

As i am in 2003, i am not able to test Cutter's formula but i think is also can works for you

[Backroomgeeza]

i think both work

thanks again for your help