count & count ifs

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

I have four columns for attendance for each quarter. How do I count if all four are blank for a person and then total that at the end? The highlighted cells are representative the person did not attend all year.

I am looking for an automatic way to identify overlap and still count totals acurately. This might take a bit of explaining. In the table below, Columns A,B and C show values 1 through to 50 group in data sets. The first row, I am looking at lines 1 through to 10 which is a total of 10 lines...

Hi, I have a question and would kindly ask for your help to figure this out. Table 1, represents the date in which each product was acquired and the price paid for it. I want to perform a search in this table so it returns the price of a product to its closest registered date. TABLE 1...

These cells are conditionally formatted to be red if the cell directly above is less than it and green if it's greater than. Each cell contains a simple function of SUM the row to the left plus the cell directly above it. I'm pretty new to Excel so I've been testing functions out, and now I'm...