count if meets criteria

  1. J

    Excel Formula using IF and Countif to count number of matching Text in a column

    =IF(F:F="29.04.2021",COUNTIF(E3:E1000,"ok")) =IF(F:F="30.04.2021",COUNTIF(D3:D1000,"Afternoon")) I am using this formula, if column F:F there is text "29.04.2021" then against that row if there are any "ok" in column E:E1000 then it will count the number of "ok" in the designated cell, but...
  2. R

    Need help with formula

    Currently this counts if anything is entered in the cell range. I want it to count .5 if the value is lower case, 1 if the value is upper case, and 0 if no value. Your help is appreciated! =COUNTA(April[@[1]:[31]])
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top