Couting the number of referrences that...

  • Thread starter Thread starter speakers_86
  • Start date Start date
S

speakers_86

What formula can i use that can count the number of rows that have
specified text?

for example:
A B C
Stevens Water Job Job secured

if this were one record of many, i need a formula to count the number
of records that say water job and job secured.
 
im not in the office now, but that looks like it will work. How do I
add another criteria? i need to know how many records say water AND
secured

i appreciate your help.
 
actually thats not exactly what i need. if a job comes in, it is
classified as mold, water, fire damage, etc. Then, there is the status
of the job. Wether it was secured, no job, pending. im looking for a
formula that will look for water jobs in one column, then out of those
jobs, count the number that are no job. thnx
 
Hi!

Try this:

=SUMPRODUCT(--(B1:B10="water job"),--(C1:C10="no job"))

Better to use cells to hold the criteria:

D1 = water job
E1 = no job

=SUMPRODUCT(--(B1:B10=D1),--(C1:C10=E1))

Biff

"speakers_86" <[email protected]>
wrote in message
news:[email protected]...
 
None of those formulas seem to work. I need a =countif that reffers to
a different sheet and looks at two ranges and two different criterias.
 
"speakers_86" wrote...
None of those formulas seem to work. I need a =countif that reffers to
a different sheet and looks at two ranges and two different criterias.
Click to expand...

Ok...

Tell us EXACTLY which sheet and EXACTLY which two ranges and EXACTLY what
the two criteria are.

Biff
 
The sheet is called master copy
range J:J criteria Water
range L:L criteria no job

thanks biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
Excel Drag autofill only part of formula 3
calculated fields in pivot tables 1
Pivot Table Calculate Field 1
Countif 4
Count unique 4
Not sure if count is the correct formula... Excel 2002 3
How to count occurrences where 2 columns are required to be true? 1

Back
Top