Custom COUNTIF

  • Thread starter Thread starter brianc0428
  • Start date Start date
B

brianc0428

I have a spreadsheet with 5 colums: ID#,Date Entered, Entered BY, Dat
received and SLA. What I want is help creating a formula that will giv
me the total number of times the SLA was missed by Entered By. There
10 users.

Thanks in advance,

Bria
 
Hi Brian

not sure exactly what you're after but i think that the subtotal
functionality (Data / Subtotal) might be what you're looking for - but sort
first on Entered BY

Cheers
JulieD
 
The value in the "Entered By" column is a name. I want to relate th
number of missed "SLA" to the "Entered By" name. I want it to look lik
this
Joe=5
Bill=7 etc
 
Hi
you've lost me. could you please post some example rows (plaint text -
no attachment please) and state your expected result
 
Frankk,

Sorry for not explaining well. Here is what I am looking for:

Column H Column N
Entered By SLA
waddenbr Missed
waddenbr Met
jepizarr Met
jepizarr Missed
jepizarr Met
jepizarr Missed




waddenbr 1
jepizarr 2
 
Back
Top