count cell

  1. B

    Count cells in a Pivot

    Hi, I am looking for a formula to count cells that are not empty in a pivot. The complication is that it needs to count cells/rows across multiple columns. My query would be something like the following: If anything in rows 2 to 30 in the columns D,J, and K, put "1" in this cell. I will then...
  2. H

    VBA to count number of new rows and add date in adjacent column

    Hi there, I'm quite new to VBA so any help is appreciated!! :help: I have a macro that opens Workbook A, copies the data and pastes it in Workbook B.(Sheet 1) below existing data. What i would like to do is have a code that can count the number of rows that have been added and paste the date...
  3. X

    Counting Certain Characters in a Cell with Nested IF Function

    Hello, I have the following data in cells: 1 1.12.1.1.2 1.12.1.1.3 1.12.1.1.4 1.12.1.1.4.8 1.12.1.1.5 1.12.1.1.6 1.12.1.1.7 1.12.1.1.8 1.12.1.1.9 1.12.1.1.9.9 1.12.1.1.10 1.12.1.1.10.8 1.12.1.2 1.12.2 1.12.2.1 1.12.3 1.12.3.1 1.12.3.1.1.4 1.12.3.1.1.10 1.12.3.1.2.4 1.12.3.1.3 1.12.3.1.3.1...
  4. S

    Count items that begin with digit 7 (items could be number or text)

    Excel 2007 <tbody> Row\Col A B C D E F 1 712345678 2 712345678 3 123745678 4 8234756 5 6 8234756 7 712345 8 LK 9 7123 10 Y712345 11 12 13 Answer: 14 No. of items (that are...
  5. J

    How to count SIMILAR DATA from 1 column based on string in 2nd column

    HI GUYS I AM NEW TO THIS FORUM I AM BALDY STUCK IN MAKING FORMULA IN EXCEL 2007. CAN ANY BODY TELL ME ? THIS IS THE SAMPLE DATA BELOW. I WANT TO COUNT THE " MEDIUM CELL VALUES" BASED ON " DISTRICT COLUMN VALUES" FOR EXAMPLE: IT WILL GAVE ME THE FINAL RESULT AS. DISTRICT--> JAMSHORO HAD...
  6. H

    How to count (not sum) every N th cell

    Hi, I worked on a excel sheet, which has 1429 rows. Every 21 rows means one set of data for an individual (e.g. 1-21 for one individual, 22-42 for another individual). I need to Count (not sum) every 21 cells. Currently, I am using Count function, however, if I drag it down, it counts 2nd cell...
  7. 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...
  8. K

    Excel 2007 counting across rows to the next blank cell

    Hi There, I'm looking at writing a formula to count the number of days worked since an employees last day off (results to appear in E7) From how my spreadsheet is designed, I'm needing to count the number of start/finish cells in Row 7 (F7:G7,J7:K7, and so on) until I get to a blank...
  9. C

    Need to find sequential serial numbers and group them counting # of #

    I have serial numbers on the same product that is numbered sequentially. For some reason we have sold individual serial numbers and they are no longer consecutive. I need to be able to find sequential numbers, Label them as consecutive and display how many consecutive numbers are in a group and...
  10. R

    Highlight a number of cells based on a count not value

    Hello to all, I am truly stumped. I searched but couldn't come up with anything that works. I am trying to highlight a number of cells based on a count not values. In other words if A1 has a number 5. I would like A2:A6, next 5 cells, to automatically highlight. I would prefer something in VB...
  11. C

    Counting dates in filtered row

    Hi all, I'm trying to count the number of cells that contain a date in a filtered row. I've been using the following formula, but it keeps coming back with a value of 0, even though there are 3 in the filtered row; =SUMPRODUCT(--('Fixture Status'!J3:J1000=">=0"),SUBTOTAL(3,OFFSET('Fixture...
  12. T

    Drop down menues that hide

    I am creating a table that has ridiculous amounts of duplicate date (or data that below to the first group (the example will help make sense). What I want to do is have a drop down ability to hide all the related rows. ex: tim.com tim.com/1 tim.com/12 tim.com/1/2 excel.com excel.com/1 What I...
  13. I

    Count statement to ignore £0.00 entries

    I need to know, is it possible to count the amount of entries in a column, but ignoring all cells that have £0.00 entered in to them. Im currently using a large sheet in which it has many columns of costs adding into column AH. What I plan to to is count all the cells in AH, but exclude all...
  14. Agent86

    Counting Increases and Decreases

    I have table in which every week a new set of numbers is inserted in the next available column to the right. At the top of each column I'd like to calculate two things ... 1. The number of cells that have a larger number than the prior week's number on the same row. 2. The number of cells...
  15. D

    count number of cell have the same value

    Hi I have two column A B ----------- 1 2 2 2 3 1 4 3 5 4 I want to count the number of cell in column A that have the same value of cell at the same row of column B In this example it should return 1 as A2=B2 Can you please show me how to do...

Some videos you may like

This Week's Hot Topics

Top