Convert SUMPRODUCT to COUNT

[lunker55]

I have a formula where I need to count instead of sum. Is there a way to do
this?

Joe

=SUMPRODUCT((YEAR('2003-2004'!$A$4:$A$10000)=(Summary!$B$4))*(MONTH('2003-20
04'!$A$4:$A$10000)=(Summary!$D$3))*(('2003-2004'!$I$4:$I$10000)=E4)*'2003-20
04'!$E$4:$E$10000)


I tried:

{=SUM((MONTH('2003-2004'!$A$4:$A$10000)=(Summary!$D$3)*(YEAR('2003-2004'!$A$
4:$A$10000)=(Summary!$B$4)*(('2003-2004'!$I$4:$I$10000)=(Summary!E4)))))}

 

[Andy B]

Hi

Just take out the bit that is the summing part.
If it's '2003-2004'!$E$4:$E$10000, just drop it off the end to become:
=SUMPRODUCT((YEAR('2003-2004'!$A$4:$A$10000)=(Summary!$B$4))*(MONTH('2003-20
04'!$A$4:$A$10000)=(Summary!$D$3))*(('2003-2004'!$I$4:$I$10000)=E4))

 

[DNF Karran]

Does COUNT not work in place of SUM?

 

[Ken Wright]

No

 

[lunker55]

Thank you VERY much Andy!

Joe

Hi

Just take out the bit that is the summing part.
If it's '2003-2004'!$E$4:$E$10000, just drop it off the end to become:
=SUMPRODUCT((YEAR('2003-2004'!$A$4:$A$10000)=(Summary!$B$4))*(MONTH('2003-20
04'!$A$4:$A$10000)=(Summary!$D$3))*(('2003-2004'!$I$4:$I$10000)=E4))


--
Andy.



=SUMPRODUCT((YEAR('2003-2004'!$A$4:$A$10000)=(Summary!$B$4))*(MONTH('2003-20
04'!$A$4:$A$10000)=(Summary!$D$3))*(('2003-2004'!$I$4:$I$10000)=E4)*'2003-20
{=SUM((MONTH('2003-2004'!$A$4:$A$10000)=(Summary!$D$3)*(YEAR('2003-2004'!$A$