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

=SUMPRODUCT(--(rng1="criteria1"),--(rng2="criteria2"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

If you just want the SUM of the two counts, then........

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

Vaya con Dios,
Chuck, CABGx3



"Chip Smith" wrote:

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

Look at SUMPRODUCT

=SUMPRODUCT(--(A1:A100="Criteria1"),--(D1:D100="criteria2"))

Ranges must be same dimensions (rows/columns).

"Chip Smith" wrote:

i need to do a count based on two differnt criteria and two different
ranges...like a =countif((range,criteria)&(range,criteria)) or something of
that nature
--
--Chip Smith--
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 :)


"CLR" wrote:

If you just want the SUM of the two counts, then........

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

Vaya con Dios,
Chuck, CABGx3



"Chip Smith" wrote:

i need to do a count based on two differnt criteria and two different
ranges...like a =countif((range,criteria)&(range,criteria)) or something of
that nature
--
--Chip Smith--
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 ---- "Green"
If the criteria is a numeric value don't enclose it in quotes ---- 10

Biff

"Chip Smith" wrote in message
...
i need to do a count based on two differnt criteria and two different
ranges...like a =countif((range,criteria)&(range,criteria)) or something
of
that nature
--
--Chip Smith--
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 :)


"Bob Phillips" wrote:

=SUMPRODUCT(--(rng1="criteria1"),--(rng2="criteria2"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

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

http://nwexcelsolutions.com


"Chip Smith" wrote in message
...
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 :)


"Bob Phillips" wrote:

=SUMPRODUCT(--(rng1="criteria1"),--(rng2="criteria2"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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