count

  1. M

    Count the Number of Sick Occasions in Dax - Calculated Column - PowerBI

    Hi All, I was wondering if anyone know how to count the number of Sick Occasions in Dax? i know how in Excel but dax is a completely different beast. Looking at the example i have posted. I want it to show 0 if they were not absent. Then increment once they become absent. But then they return...
  2. mohsinbipu

    Count the occurrence with the array formula

    Hello Excel lovers, For a better understanding, please find the picture. Here, my input Column is I, J, K My output column is the P column (I want to get the Xlookup result for nth number.) To count the number of occurrences, I add a helper column L I don't want to add this helper column. I...
  3. S

    Count across a data set or index

    Hi, I need a count formula that counts names across multiple columns. I need to know how many people attended Philadephia. The answer is 5. Then pull the formal down to know how many attended Orlando = 6. please note the blank cells are blank b/c there is a formula iferror return "" A1 first...
  4. M

    Count non-formula cells in range???

    Good evening fellow excelers, Is there a way to write an XL formula that will count non-formulas in a range? I know this is gotta be simple to do, but I just can’t seem to wrap my mind around how to do it after about half an hour to an hour of trying. Thanks for any consideration to this...
  5. C

    Store Value and Shift down cell value

    Hey guys, I'm writing a code to count and store values to reference how often something is referenced in a class. I'm trying to write a code that counts with one button (this is complete) and stores historical values in another column. This is where I'm having issues. My counter is set in B2...
  6. V

    count based on data from another sheet

    Hi all, I've been struggling with a formula for GSheets. I have the data in another sheet and I want to count how many time does a name appear during 7 columns. Any help is greatly appreciated,
  7. P

    Count distinct if lot of condition

    Hi, please could you help me? It is difficult to explain, but I will try. I want to count distinct of Tests in my Excel table. For example for Test_1 I want to count all Tests, but only that kind of tests which have at least 1 Cond, which is in the same Cond as Test1. Result is 8 because...
  8. A

    Consecutive week count with multiple conditions

    Hi, I am after some help to count the number of consecutive weeks an individual has been paid. Difficulties with the data set are the duplicates values. I have explored and trialled countifs but haven't been able to incorporate the portion around a consecutive count. I've included an example...
  9. ibmy

    offset the formula,1 cell below to start calculation

    Hi Experts, I been thinking and try change current formula but not succesful to meet my need. Current Formula : Start from currrent cell GIJ1datatotalCount230.63240.150.860.3J3J3=IF(I3="","",COUNTIF(INDEX(G:G,ROW()+I3-1):G3,">0.5")) The best solution I have tried so far : but the result...
  10. ibmy

    SUM/COUNT of Value 1 at the Start of Set

    Hi Experts, How to get result in Column L (Start) ? GIL1DataEndStart2315415161715891111011121213121415161111718191220122122132312413252627 For Column I ( End) , I use this code : Sub End2() Dim a As Variant, b As Variant Dim i As Long, k As Long a = Range("G2", Range("G" &...
  11. IIII

    Find Saturdays that are within a set of dates

    Hi All, I currently have a function that identifies which dates between two dates are Saturdays. What I also need to know though, is how to work out if any of those Saturdays appear in a list of specified dates e.g. Leave//Holidays list of dates. So the below example shows what I'm trying to...
  12. J

    How to Count entries with date range across multiple tables and worksheets?

    Worksheet 'Dashboard' has a weekly breakdown for production numbers. I have tried multiple ways and continue to get formula errors. I need to count the number of entries in multiple other worksheets as follows: Worksheet: DG_Procedures has table DG_Table with column Date Submitted to QC. I...
  13. J

    Countif value is not blank and less than 70% of adjacent cell"s value

    Hi all, Hoping someone can help me with this. I'm guessing it super simple, but I can't find a solution anywhere online. Basically, what I'm trying to do is count the number of times each cell in a range (G4:G9) is not blank and is less than 70% of the value of the cell that is 2 columns...
  14. ibmy

    Count specific value in range

    Hi Mr Excel, How to get result in Column Q & S? Given number of range to check for Column Q in M , Column S in O The Range to check in Column G. Example : Cell O6 show 2 number of range , then check how many value < -0.6 in Column G and the result is 1 in Column S. Same goes to Column M for...
  15. tourless

    Count from/until blank not working

    Hi Folks. Starting in cell I3 I'm simply trying to count the cells with values until I reach the first blank cell. But for some reason it returns the count from I1 to the first blank cell. I have no idea why... nDays = Range("I3").End(xlDown).Row
  16. E

    Count filtered unique values where sum of values in another column meets criteria

    Hello, hope you can help. I would like to use a formula to give the count of complete projects in [time range] where there is a total of <=1 hour spent on 'review' over the whole project - example sheet below. In this sample the desired answer is 2 as only project A and B meet the criteria...
  17. T

    I'm trying to use EDATE in conditional formatting to turn cells different colours and then use COUNTIF to count green and turn this into a percentage

    The conditioning formatting worked when using "cells that contain" but other forums say that it has to be a formula to then use count function. Please can someone help without using macros as I don't understand these.
  18. A

    Excel VBA: How to count cell and whenever cell change will keep the old and new data continuously

    Hi expertise, I already enable worksheet change that will record every single data after click in specific cell. But, I have one problem onto count (preferably in range G:G) the cell within same row in multiple cell. Can anyone help me on this? Thank you. Option Explicit Private Sub...
  19. A

    Outlook VBA to count emails in inbox by Subject and send to an Excel spreadsheet

    I use the code below to count emails by Sender and send to a new Excel sheet. I would like one that will count emails in the inbox by subject line, excluding characters at the beginning (e.g. {EXTERNAL}, RE:, FW:, etc.), and send those to a new Excel sheet. Any suggestions? Sub...
  20. S

    Month Count in Google Sheets.

    Hi, I'm looking for an excel formula that can count the months from the start of positive #s to the end of positive #s. Zero values in between positive #s count. Zero values do not count before the first positive # or after the last positive #. Client 5/31/2022 4/30/2022 3/31/2022 2/28/2022...

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
Back
Top