count cells

  1. H

    Code to count number of cells

    In my Workbook there are numerous Worksheets out of which approximately 30 ws are using ‘Worksheet code’. In ‘ThisWorkbook’ also I am using a macro. In Module, I am using a ‘vba code’ for Worksheet (tab named “ZZZ”) using 'User Defined Function' to get the output in some cells wherever UDF is...
  2. S

    Count the number of cells between same values

    Hello, I need help with a formula than will count number of cells between same values. This thread has an almost ideal formula for me but I need the numbers range between 0 and 99 instead 0 and 1. In my...
  3. R

    Product tracking

    I've been trying various different formulas to have excel check a for a value in a date column that is greater than or equal to a predefined start date. Then I need it to count if the dates are within condition and product operation is complete. Eg. Start date is Monday any dates past Monday...
  4. Z

    Inventory Help?

    Hey guys! Need some help and I haven't the slightest clue where to start. I have a spreadsheet for employee clothing inventory that's sorted by what each employee has in their possession, but I need to make a 2nd sheet to account for what employees have overall. IE, Jessica has 3 skirts and so...
  5. T

    Count rows including blank rows

    Currently, this is the format I have in Excel: Column A 1 465 2 Cali 3 5466 4 5 Fifer 6 456456 7 8 JSAP 9 10 456 I want to count the whole thing, and the results should be 10. Is there a way to do this? I have tried countA formula, but result comes out to...
  6. S

    Counting each occurrence of consecutive values in a column

    Hello, I have a rather large dataset, and apart from the top row (which is a header row), all the data is either a 0 or a 1. Just looking at one column, I could have something like: <tbody> A B index data 1 0 2 0 3 1 4 1 5 1 6 0 7 0 8 0 9 1 10 1 11 0 12 1 13 1 14...
  7. T

    Counting cells for each supplier

    Dear all, I'm working on a data set which consists of suppliers, the differentproduct they sell and the amount of money corresponding to each productgroup. My goal: Count the amount of different productgroups each supplier has. In Column A you can find both the suppliers and productgroups...
  8. K

    Count only if immediate right cell is blank...sort of.

    So I have a mess I'm trying to work with. What I'm trying to do is if column G or H has a date in it (isn't blank), count the cell as 1 and return the number. While I don't have an issue with that part, my complication comes in if there's a value (not blank) in column H- that is, it counts it...
  9. C

    macro to highlight precedent cells that contribute to a count in a countif formula cell

    Hi everyone, What I want is to be able to click on a cell that has a countif formula, and then it be able to highlight all cells that contribute to the countif answer. I want it to be an automatic macro so that when I click on the cell with the formula, all the cells that apply to the countif...
  10. littlepete

    Excel element that slow down working

    hello i have a general question about things that slow down working on excel : 1. i noticed that a column with numbers (2000 rows) and conditional formatting on each of those numbers, depending on some conditions, slow down the whole excel filtering jobs ! (dramatically) 2. adding a formula...
  11. R

    Need help counting cells that contain any number but not exact string TR is in the cell

    Hello all, Thanks in advance for looking and hopefully you'll be able to help me. I've created a restaurant work schedule and want to count how many staff members are scheduled. I only want to count cells that contain ANY number in them BUT NOT cells that contain any number plus the exact...
  12. P

    Make a workload of a particular teacher

    Help Required My problem is i want to past the complete cell of that particular teacher with (subject, name of that teacher & Class) in there receptive ROW, it will help me to know which subject & Teacher and which class that particular teacher is teaching in "Sheet 1" i have highlighted...
  13. C

    Count if - text could be in one of 6 columns per row

    Hi there, I have a set of data where the sales rep. creates a visit report. His name can appear in one of 6 fields. I want to count the number of visits and only once per sales rep. per visit. The name can appear on one of 6 columns and not always in the first. How can I count the first...
  14. A

    Counting Characters To 60 And Shift to Next Column (Shift Right)

    Hi all, I've had a good look and I can't find exactly what I'm looking for which is: I get a spreadsheet with, sometimes, 500 chars in a cell. I want to load this data to an application but I can only load up to 60 characters per column (for reasons I shan't bore you). Therefore I want to...

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