Counting the number of occurances of a number if a condition is met in an
adjacent column on the same row

Hi

if you have two conditions - the number you want to count & the condition in
an adjacent cell you'll need to use the SUMPRODUCT function, e.g.
=SUMPRODUCT(--(A1:A100=3),--(B1:B100="Red"))

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

for more details on the sumproduct function.

Cheers
julieD

"jrm" wrote in message
...
Counting the number of occurances of a number if a condition is met in an
adjacent column on the same row

That's what it does. Have you looked in HELP index for COUNTIF

--
Don Guillett
SalesAid Software

"jrm" wrote in message
...
Counting the number of occurances of a number if a condition is met in an
adjacent column on the same row

perfectly described, what is the problem?

--

HTH

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


"jrm" wrote in message
...
Counting the number of occurances of a number if a condition is met in an
adjacent column on the same row