count function

  1. S

    Is there a way to count values that are of a certain criteria when they are in an array.

    Hi, I have this function, for simplicity's sake it is provided below: =FREQUENCY(IF(A1:J1<>"", COLUMN(A1:J1)),IF(A1:J1="",COLUMN(A1:J1))) Cells A1:Z1 are populated with a series of number with blank cells in between them, and the function above calculates how many cells are in a row until a...
  2. T

    Collecting lottery data and need to count how many times a pair of numbers shows up

    Greetings!;) New forum member here and a novice at best at Excel. Could use some help, not able to solve my problem on my own. ---I'm struggling at the moment trying to find the correct formula that will count how many times a pair of numbers are showing up together. I'm using MS Office 2016...
  3. V

    Multiple Value Possibilities & Conditions

    I have multiple products that have a certain price associated with them depending on what product group they belong to. Their product group is identified by a 2 letter prefix in the Product Title. I want to say, if the Product Title cell contains "AB", then Price = the AB Group Price. It would...
  4. S

    A wee bit of difficulty with Count Function

    Hey everyone, This is going to probably be one of those "D'OH!" questions but here I go. I have a range (C2:C32) that has some zero values. I need to average the range WITHOUT the zeros. I believe that a counting function would work, but of course I am having one of those blonde moments that...
  5. P

    CountIf with conditions

    Hi all, I'm hoping someone here can help me solve this formula if it is at all possible. Here's the short story of the problem: Columns and their representation: Columns A through C represents an overview of data collected. A = Names B = Errors YTD C = Errors MTD Columns D through H are...
  6. S

    Count Function in Pivot Tables

    Hi, I have a spreadsheet full of sales data, I would like to create a pivot table that will count a certain sales outcome for a given sales medium. I made a cast of what I mean - >> http://screencast.com/t/ZThlOTE5ODQ Any ideas, I would great appreciate it. Thanks
  7. S

    Count Function In Pivot Tables

    Hi, I have a spreadsheet full of sales data, I would like to create a pivot table that will count a certain sales outcome for a given sales medium. I made a cast of what I mean - >> http://screencast.com/t/ZThlOTE5ODQ Any ideas, I would great appreciate it. Thanks

Some videos you may like

This Week's Hot Topics

Top