count if meets criteria

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

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]])

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

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

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

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

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

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

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

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

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