count & count ifs

Hello, I have a large data table with "create date" and "status" fields. How can I count the number of statuses within a date range using cell references? Specifically, I would like to count the number of "closed," "resolved," etc. statuses from the date range specified in cells D2 through E2...

I have a rainfall table and the google sheet link is provided below. For each year, I want to count number of days, fulfilling following both two conditions: 1) Number of days where rainfall is more than or equal to 1 mm. 2) Count only those days which are not single. In other words, I want to...

Hey guys, I needed a formula to count the below - e.g. picking up name “Alex” as a criteria, ignoring both blank cells and nil value in Value column. So, for the below example count for Alex with value should be 1. And essentially cleansing rows with blank value cell is not an option. Thanks...

I can't seem to figure out why I can't count the number of cells in a range that meet a given criteria. E.g. if the table below was a range A1: D4, count the number of cells >=.25 or <=-.25, should result in 4 My formula: =COUNTIFS(AM78:BC85,">=.25",AM78:BC85,"<=-.25") .1 .05 .2 .25 .4 .5...

Hi, and thank-you in advance for your assistance... Column 'A' contains a set of order numbers. These may be duplicated if a sales order has more than 1 product. Column 'B' has the date of sale in every row regardless of whether the order number is duplicated or not. So, i am trying really...

Hiya, I have a workbook that I drop data into on a daily basis and I've got an issue getting a count to work for a time column. The column is just times, C:C, in order but they change thought the day depending on the workload done. So for instance right now the times range from 13:15 past...

Hello! :) I have about 50 sheets that contain a small amount of data. I have a name in A and the data I need in E. For example, "Jane Smith" is in A, and E says she worked virtually that week. Sheet 2 is the following week, and so on. I need to find out how many times Jane worked virtually or...

Hi. I have a spreadsheet for some assessment results (See my other posts). the cells are condition formatted so that they turn red when the assessment has failed. I am trying to get a formula to count the cells that have turned red, for each individual trainee, however the normal count functions...

Can someone please fix this Google Sheet for me? I need it desperately for work. I cannot figure out what I'm doing wrong, and every formula I've looked up doesn't work for me. It's driving me CRAZY! o_O I've highlighted the columns that are giving me issues in yellow (sheet linked at bottom of...

Hello, I have a problem in Excel using the countif formula. I want to count all the values that are more than 0 in column C in column L As per the below image, Col A is Date, Col B is Symbol, Col C is PIPS Count (value of col B) In Col J, there is again Symbol and in Col K is counting of...

Hello, I am using the formula below to create some summary information. But I am having trouble with the first part of the formula (in green font). I need it to include "01 OR "04". Any ideas? Thanks...

Hi, I'm wanting to count the number of 'Yes' values in columns B and C, but only count the 'Yes' values after the last entry in column D for the associated location. In the attached example, for Kettering the count should result in 1, as there is only 1 'Yes' in columns B and C if we count...

Howdy! I am trying to create a simple way to count apartment units that are being painted by a vendor or in-house. The goal would be to count if all 3 cells match which would identify a full unit compared to partial. I tried using...

Hi, I got small problem. I cannot find a way to formulate a suitable formula. I hope you can help me. I have to count how many of the people who worked on the DON project were between the 16 and 24 years, male, from China. I need to include all of this as of 12/31/2015. Most important is fact...

Hey guys! I am looking a way out to get the number of unique customer that have bought product in year 2011. And the table contains full date from 2011 to 2013. I have been using =SUM(COUNTIFS(Table1[Date],">="&DATE(2011,1,1),Table1[Date],"<="&DATE(2011,12,31))) to get the number of rows that...

Hi, I am struggling to create a formula that returns a singular count for data sets over 2 columns (that are multiple columns away from each other). I want the formula to count something only if: It is only counting any number in Column A once. It is also only counting the unique number in...

I am making a meeting overview of an event. I create each meeting down the rows and mark an "x" under each participant and time of the meeting (both along the columns). Hereafter I would like to make separate cellar overview where it automatically marks "free", "booked" or "double-booked" for...

Hello, I have created a master inventory excel sheet to keep track of all my inventory. It consists of 4 tabs; Lists, Shipping Log, Receiving Log, and Inventory On my Inventory sheet, I am wanting to add any merchandise from the receiving log to the previous inventory on the 'Lists' tab. At...

Hello, looking to have a recap table of attendance as follows: - From the dropdown list you choose between 3 options and i'd like to have a count of sick days, timeoff and Tardiness for each employee for March, April... What formula would fit in ? I tried with some Countifs mixed with...

Hi, Having trouble counting items in a table using VBA. I'll post a very simple example here to explain. I am trying to use VBA to count for each row all the cells with "x" in the above table, only when the cell in Col C = "A" Here is my code, but it's wrong of course. It is only counting...