excel formula

[D]

Scenario is this: have excel table with multiple columns
and several hundred records. Each individual column may
have repeated value (Text, no numbers. Say column A
contains text values of "A, B, C, D, E, etc., (duplicates
allowed) and column B contains a list of names (duplicates
allowed).

What I want to be able to do is find the total number of
value "C" in Column A that is associated with the city in
column B. I assume it may require a count, countif, and
or andif command. I just can't combine the search on two
columns to get the result.

 

[Thomas]

try sumproduct
=SUMPRODUCT((A1:A10="A")*(A1:A10="Atlanta"))

 

[Thomas]

Sorry should have been

=SUMPRODUCT((A1:A10="A")*(B1:B10="Atlanta"))

 

[Bob Tulk]

Insert a third column with a formula like =A1&B1. Then
do a sumif on these values.

 

[Myrna Larson]

I think you meant B1:B10 ="Atlanta".

try sumproduct
=SUMPRODUCT((A1:A10="A")*(A1:A10="Atlanta"))

 

[D]

Didn't seem to work. I don't think I explained what I am
trying to do very well. So, what I want to do is
something like:

Count(A:A) if (A:A = "xx") and (B:B = "yy")

I'm just starting to work with multiple expressions in
formulas and don't know the proper use of operators. Any
suggestions are appreciated.

D

 

[Thomas]

Don't select the whole column,just enter the range you need.

 

[D]

Thanks. Worked fine on the real worksheet.
D

-----Original Message-----
Thanks. It seems to work on a dummy worksheet. I'll have
to try it on the real one.

D column search
.