Multiple Criteria using countif

[calmo]

I'm trying to count the number of records in one worksheet and return the
results in a different workbook. The data is held in two different columns.
I nned to search for all cells where the value is "m" or "c" in D160,
whilst column A1:A60 should contain "*Work*".
Sorry if I'm not explaining myself properly, I'm new to this! Any help
greatly appreciated.

 

[Peo Sjoblom]

One way

=SUMPRODUCT((ISNUMBER(SEARCH("work",A1:A60)))*((D160={"m","c"})))

 

[Bob Phillips]

=SUMPRODUCT(--(ISNUMBER(FIND("Work",A1:A60))),--(ISNUMBER(MATCH(D160,{"c",
"m"},0))))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[RagDyeR]

I'm assuming that the asterisks around "*Work*" indicate that there may be
characters before and/or after the string in the cell.

Start by entering this in the sheet containing the data:

=SUMPRODUCT((ISNUMBER(SEARCH("work",A1:A60)))*(D160={"m","c"}))

Now, open the *other* WB, and copy this formula to it, which will allow XL
to create the proper path for you.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I'm trying to count the number of records in one worksheet and return the
results in a different workbook. The data is held in two different columns.
I nned to search for all cells where the value is "m" or "c" in D160,
whilst column A1:A60 should contain "*Work*".
Sorry if I'm not explaining myself properly, I'm new to this! Any help
greatly appreciated.

 

[calmo]

This was perfect, thanks for your help.

 

[Jim]

RagDyeR, will you give mine a shot?

I am trying to figure out a countif formula. Here is the explanation:

Worksheet one (my data dump page): In column A I have store names listed.
In column B I have the amount of each sale for that store.

Worksheet two: In column A I have the store names listed. In column B I
would like to have a count of $0.00 sales made for each store. The data on
the first sheet shows $0.00 sales as 0.

Thanks for the help.

 

[Bob Phillips]

=SUMIF(Sheet1!$A:$A,A1,Sheet1!$B$B)

--

HTH

RP
(remove nothere from the email address if mailing direct)