count if meets criteria

  1. Z

    need help with countif formula

    hi, i have a table called mytransaction. in this table there is a column, R, to indicate the user has checked on the transaction. there is also another collumn call source where they select which account is involve in that transaction. so now in one of the cell i would like to count how many...
  2. R

    Count Values based on multiple critiera

    Hi All, I want to count the total number of Pass and Fail based on Column 1 (Originating) site. For. Eg., If I select US, I should get 3 pass and 1 Fails, and if I select UK I should get 1 pass and 1 fails. Can someone please help? <tbody> Originating Site Description US Pass US Pass UK...
  3. D

    Counting using criteria in different columns

    Hello MrExcel Members Could you please help me with this. I have a database in which: Column E contains place names, ie: London, Cardiff, etc Column G contains abbreviated departmental names, ie: EM, FEE, etc Column P contains a number, ie: 1.0 or 0.4 or 0.6 etc At the moment, I create a...
  4. apgmin

    Count if

    I need a help with the following: A1 to h1 will have a default value of either 1 or blank ( this indicates the number of attempts the student makes for the exam ) Now in Cell J1 I want the response "module repeated" if any of the values from A1 to H1 is changed from 1 to 2 or 3 or 4 etc...
  5. D

    How do I count one column dependent on value in another column?

    I have a spreadsheet of staff a little like this (but with hundreds of names in several locations or different departments: A B C 1 NAME LOCATION EFT 2 Fred Bloggs London...
  6. K

    count if or sum if formula

    Hello I am trying to count all my past due deals by type Column A (Type) Column B ( # of days) Wholesale 8 5 9 2 Cash 9...
  7. G

    Count when someone works between the hours of 17:00 and 19:00 during the weekend

    <colgroup><col><col></colgroup><tbody> Hi, I have a spreadsheet for working weekly on-call and I'm trying to create a formula for counting how many times work was carried out on a weekend between 17:00 and 19:00 hours. I tried something like this, which is not working: <code...
  8. J

    Ayuda Contar Si (dos criterios)

    Muy buenas, Tengo un problema con la fucnión Contar.Si, para dos criterios. La cosa es que tengo dos columnas: Columna A (Formato fecha)|Columna B (Formato texto) 01/01/2002|Si 02/05/2002|No 02/05/2002|No 02/05/2002|Si 02/05/2003|No 02/05/2003|Si 02/05/2003|No 02/05/2003|Si Ahora me...
  9. lcrooke

    Counting records

    I have a spreadsheet with the following structure: Date Type Jan Feb Mar 1/15/2009 corp $1,000 1/31/2009 vendor $3,000 2/12/2009 corp $5,000 2/20/2009 renewal $1,500 3/1/2009...

Some videos you may like

This Week's Hot Topics