Ifcount + and

[Charles Woll]

I need the number of items in a table that meet 2 conditions Parcing a
string for content and with a certain zip code.
I can't seem to get the syntax correct for the countif and the "and"
portion.

--
\\\|///
\\ ~ ~ //
( @ @ )
--oOOo-(_)-oOOo---
Charlie Woll

 

[Bob Phillips]

=SUMPRODUCT(--(A2:A200="string"),--(B2:B200="zip code"))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Charles Woll]

Bob, what is the significance of the "--" double dash?

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Charles Woll]

Great page.. I will study it.
Another question, in the formula
=SUMPRODUCT(--('Transactions through December
1'!A2538:A17875="115090171"),--('Transactions through December
1'!S2538:S17875="38558"))



I tried to replace the ranges with a named range but excel won't take the
name range. i.e. S2538:S17875 become ZIP.
!ZIP="38558"))
What am I doing wrong?

 

[Bob Phillips]

Take the page of, the name includes it

=SUMPRODUCT(--('Transactions through December
1'!A2538:A17875="115090171"),--(ZIP="38558"))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Charles Woll]

Thank you Bob, you have been most helpful.
charlie

 

[Vitalie Ciobanu]

here is another eample of doing it
http://www.officearticles.com/excel/count_using_multiple_criteria_in_microsoft_excel.htm