Also, check out http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Wazooli" wrote in message
...
Thank you gentlemen. Much appreciated.

"Bernard Liengme" wrote:

COUNTIF has only one criterion (notwithstanding that Help calls the last
parameter "criteria" in the plural) so there is equivalent to your
formula.

best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Wazooli" wrote in message
...
Given the following array:

1024 20
100 30
600 20
700 10
800 10

Is there a COUNTIF equivalent to the following formula?
=SUMPRODUCT(--(A4:A8200),--(A4:A8/B4:B8=30))

I am just starting to appreciate the power of SUMPRODUCT, so I want to
try
and understand limitations of it as well as replacement functions.