count if meets criteria

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top