counting

Hello, I am struggling to create a formula, which will count the most frequent values from column A, based on the values from column B. For instance, I would like to check the top 3 (most frequent ones) text values in column A, but only for the ones which have value equal to 1 in column B, same...

I have the following number and LEN() formula, As you can see that LEN(), counting 15 for all other and 16 for the last one, while they all 16 characters long. <form id="form" onkeypress="javascript:return WebForm_FireDefaultButton(event, 'cphMain_btnSearch')" onsubmit="javascript:return...

ok i have a SIMPLE simple question...... I have the following file and it contains the following formula: =COUNTIFS(E:E,A3,D:D,">="&$A$1,D:D,"<="&$B$1) it basically counts the number of instances of user1 within a range of dates on cells A1 and B1 however it doesn't work for user1 (should...

Hello - i have below formula in a cell IF(ISBLANK(C13),"",$E$5) but C13 has formula in it so it doesn't consider it as blank is there a way around it? please. thanks

I recently asked about counting "occurrences" and "half-occurrences" in an absence calendar. The premise is that row 1 contains a value indicating an absence (UP = unplanned, T = Tardy, LE - Leave Early) If the absence is .25 of an hour up to 2 hours, it's half an occurrence, if it's 2 hours or...

Two questions ... is there a formula that will count conditionally? In other words count the number of times the code "j" appears in a column. Second ... I have one column that subtract time and the result is in minutes in this format "00:07:23" I need this as a decimal by either altering...

The pivot table below is counting the number of tickets handled by agents on each row (by counting the reference numbers that appear in the data set against each name on any given day). Where the corresponding date is blank in the pivot table the assumption is the agent didn't work. I'd like...

Hello How do I do this, please someone please point me in the right direction?? If a row contains a single 'NO' (like Row 1) I'd like to count that as one. If a row contains multiple instances of 'NO' (like Row 2) I'd like that to be counted just as one. I'm not interested in counting the...

Hi all, I recently started using Excel and have been trying to solve a problem involve sorting and counting. I'm sure it's been encountered many times before, but am having trouble figuring it out. I tried searching for answers on the forums, but was having trouble putting my question into...

Hello Guys, I probably have a silly question but it blocked me totally :-) I have a below formula, which is counting the data from one sheet: Dim IMPORTcount As Integer IMPORTcount = Sheets("IMPORT").Cells(ROWS.Count, "A").End(xlUp).Row and I have also second formula, which is counting X's...

The other day I posted a question on counting attached files to emails in outlook. Had a great answer and the following VBA. So the new problem is it works to good. Its counting everything in the email as an attached file. I been looking to see if others may have had a solution to filter out...

Hi there, I have a searched through the forums, and may be searching via the wrong words, but am having challenges putting together probably a relatively simple formula. I need Excel to automatically update a numbered column when a cell may be deleted or changed to alternative text, for...

Hey Guys, I'm trying to have excel count numbers and ranges of numbers all within one cell. I'm aware of =Len(A1) etc but that gives me a character count which isn't helpful. So for example: 1, 3–5, 14–18, 20–26, 29, 30, 33, and 34 are all in one cell. I'd like excel to count the digits...

Hello Everyone, I have an excel column containing some entries. I want to check how many times each entry of the column appears in that whole column. E.g if the A1 CELL contains "Elephant" and A2 CELL contains "Elephant Rabbit" then the count of "Elephant" in A1 should be...

Hello. In columns A and B (A3:B802) I have a list of 25 different products (Product 1 - Product 25) with their corresponding 'markers' in columns C and D (when Product is in column A his 'marker' is in the same row in column C, and when Product is in column B his 'marker' is in the same row but...

I would like to count specific rows in a spreadsheet. For example see below.. Failed XMLs tran_log_id origin_id reference_id result_code last_updated_dttm 11421022 OMS OMS_39794575 25 01:30.7 11421023 OMS OMS_39794575 25 01:47.2 I have repeated data with different...

<tbody> JT00295576 JT00350215 H048579632 MT00394791 M040529851 J041757899 HT005262686 J017612581 MT00220848 JT00371377 MT00337725 H042053736 </tbody> So I am trying to find a formula that would count how many accounts are listed; there are 12 accts in the example. most...

Dears kindly help me with this I have this table The expected result is in column No. of Days So it must count number of days for these Products (1010,1030,1040,1020) I have this formula which give similar results but for dates that have gap like 21\01 then 24\01 here it will jump from...

Hello I have a dataset with about 200 different post codes spread across 6,000 company names. I want to find out how many companies are in each post code. how should i do it? hopefully, my end product is a bell curve distribution chart..

I have a workbook that I use to keep track of volunteers. One sheet per month, along with a totals sheet. I use the formula =SUMPRODUCT((B7:B150<>"")/COUNTIF(B7:B150,B7:B150&"")) to count the number of unduplicated volunteers per month, but I need to count the number of unduplicated volunteers...