software

I want to count the number of instances where 2 separate conditions are each
met e.g. the number of times when column A has a value of quot;xquot; AND column B
simultaneously has a value of quot;yquot; (actually one would be a numerical value
and one text). I am getting confused looking at the help section for array
formulae.
Help?!

You can use an array formula or just a helper column:

In an un-used column enter:

=AND(A1=quot;xquot;,B1=quot;yquot;)*1 and copy down. Then just sum the contents of the new
column.
--
Gary's Studentquot;Richard pilequot; wrote:

gt; I want to count the number of instances where 2 separate conditions are each
gt; met e.g. the number of times when column A has a value of quot;xquot; AND column B
gt; simultaneously has a value of quot;yquot; (actually one would be a numerical value
gt; and one text). I am getting confused looking at the help section for array
gt; formulae.
gt; Help?!

For a single formula approach, try something like this:

For numbers in Col_A and text in Col_B

This formula counts to number of times Col_A contains the number 1 when
Col_B contains the letter quot;dquot;:
C1: =SUMPRODUCT((A1:A10=1)*(B1:B10=quot;dquot;))

Adjust range references to suit your situation.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Richard pilequot; wrote:

gt; I want to count the number of instances where 2 separate conditions are each
gt; met e.g. the number of times when column A has a value of quot;xquot; AND column B
gt; simultaneously has a value of quot;yquot; (actually one would be a numerical value
gt; and one text). I am getting confused looking at the help section for array
gt; formulae.
gt; Help?!

=sumproduct(--(a1:a10=quot;xquot;),--(b1:b10=33))

Change the range--but don't use the whole column.

Richard pile wrote:
gt;
gt; I want to count the number of instances where 2 separate conditions are each
gt; met e.g. the number of times when column A has a value of quot;xquot; AND column B
gt; simultaneously has a value of quot;yquot; (actually one would be a numerical value
gt; and one text). I am getting confused looking at the help section for array
gt; formulae.
gt; Help?!

--

Dave Peterson

Try this:

if X is in C1 and Y is in D1 then
=SUMPRODUCT((A1:A10=C1)*(B1:B10=D1))
or
=SUMPRODUCT((A1:A10=x)*(B1:B10=quot;yquot;))
where x = nemerical value (without quotes) and y = text (inside quotes) or
vise versa

HTH
Jean-Guy

quot;Richard pilequot; wrote:

gt; I want to count the number of instances where 2 separate conditions are each
gt; met e.g. the number of times when column A has a value of quot;xquot; AND column B
gt; simultaneously has a value of quot;yquot; (actually one would be a numerical value
gt; and one text). I am getting confused looking at the help section for array
gt; formulae.
gt; Help?!