Couting the number of referrences that...

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.
 
S

speakers_86

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.
 
S

speakers_86

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
 
S

speakers_86

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.
 
B

Biff

"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
 
S

speakers_86

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

thanks biff
 
Top