software

i need to do a count based on two differnt criteria and two different
ranges...like a =countif((range,criteria)amp;(range,criteria)) or something of
that nature
--
--Chip Smith--
MVP Wannabe

=SUMPRODUCT(--(rng1=quot;criteria1quot;),--(rng2=quot;criteria2quot;))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Chip Smithquot; gt; wrote in message
...
gt; i need to do a count based on two differnt criteria and two different
gt; ranges...like a =countif((range,criteria)amp;(range,criteria)) or something
of
gt; that nature
gt; --
gt; --Chip Smith--
gt; MVP Wannabe
If you just want the SUM of the two counts, then........

=countif(range,criteria) countif(range,criteria)

Vaya con Dios,
Chuck, CABGx3
quot;Chip Smithquot; wrote:

gt; i need to do a count based on two differnt criteria and two different
gt; ranges...like a =countif((range,criteria)amp;(range,criteria)) or something of
gt; that nature
gt; --
gt; --Chip Smith--
gt; MVP Wannabe

Look at SUMPRODUCT

=SUMPRODUCT(--(A1:A100=quot;Criteria1quot;),--(D1100=quot;criteria2quot;))

Ranges must be same dimensions (rows/columns).

quot;Chip Smithquot; wrote:

gt; i need to do a count based on two differnt criteria and two different
gt; ranges...like a =countif((range,criteria)amp;(range,criteria)) or something of
gt; that nature
gt; --
gt; --Chip Smith--
gt; MVP Wannabe

no i need it to meet both criterias in order for it to count them...maybe a
macro would suite better for this?

--
--Chip Smith--
MVP Wannabe quot;CLRquot; wrote:

gt; If you just want the SUM of the two counts, then........
gt;
gt; =countif(range,criteria) countif(range,criteria)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Chip Smithquot; wrote:
gt;
gt; gt; i need to do a count based on two differnt criteria and two different
gt; gt; ranges...like a =countif((range,criteria)amp;(range,criteria)) or something of
gt; gt; that nature
gt; gt; --
gt; gt; --Chip Smith--
gt; gt; MVP Wannabe

Hi!

=SUMPRODUCT(--(Range1=Criteria1),--(Range2=Criteria2))

Ranges cannot be entire columns ---- A:A (entire rows is ok ---- 1:1)
Ranges must be the exact same size: Range1 = A1:A10 ---- Range2 = H1:H10 or
A1:A10 ---- H11:H20
If the criteria is a text value enclose it in quotes ---- quot;Greenquot;
If the criteria is a numeric value don't enclose it in quotes ---- 10

Biff

quot;Chip Smithquot; gt; wrote in message
...
gt;i need to do a count based on two differnt criteria and two different
gt; ranges...like a =countif((range,criteria)amp;(range,criteria)) or something
gt; of
gt; that nature
gt; --
gt; --Chip Smith--
gt; MVP Wannabe
now what if one of the arrays is in the format of a date mm/yy or as mmm? hat
wouldn't be considered text, would it??
--
--Chip Smith--
MVP Wannabe quot;Bob Phillipsquot; wrote:

gt; =SUMPRODUCT(--(rng1=quot;criteria1quot;),--(rng2=quot;criteria2quot;))
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Chip Smithquot; gt; wrote in message
gt; ...
gt; gt; i need to do a count based on two differnt criteria and two different
gt; gt; ranges...like a =countif((range,criteria)amp;(range,criteria)) or something
gt; of
gt; gt; that nature
gt; gt; --
gt; gt; --Chip Smith--
gt; gt; MVP Wannabe
gt;
gt;
gt;

It depends on if it is text, if you type in January in a cell it is text, if
you type in 01/01/06 in a cell and format it to mmmm which would read as
January it is not text

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Chip Smithquot; gt; wrote in message
...
gt; now what if one of the arrays is in the format of a date mm/yy or as mmm?
gt; hat
gt; wouldn't be considered text, would it??
gt; --
gt; --Chip Smith--
gt; MVP Wannabe
gt;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt;gt; =SUMPRODUCT(--(rng1=quot;criteria1quot;),--(rng2=quot;criteria2quot;))
gt;gt;
gt;gt; --
gt;gt; HTH
gt;gt;
gt;gt; Bob Phillips
gt;gt;
gt;gt; (remove nothere from email address if mailing direct)
gt;gt;
gt;gt; quot;Chip Smithquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; i need to do a count based on two differnt criteria and two different
gt;gt; gt; ranges...like a =countif((range,criteria)amp;(range,criteria)) or
gt;gt; gt; something
gt;gt; of
gt;gt; gt; that nature
gt;gt; gt; --
gt;gt; gt; --Chip Smith--
gt;gt; gt; MVP Wannabe
gt;gt;
gt;gt;
gt;gt;