• Home
  • Excel Formulas
  • Excel Functions
  • Excel VBA
  • Help us Answer Questions
  • Ask a Question
Home / Posts tagged count

Calculating a sum of certain data based on other dats

I am trying to see how a mailing affects the response rate of customers over the next week after it is sent. I want to do some sort of SUM IF fucntion but I …

October 3, 2018 | Excel 2003 Help, Excel 2010 Help | 0 Comments

find, count, return title

I have a timetable for my school.  In the first column are the staff.  Across the rows are the days of the week.  The content of the table is …

June 14, 2018 | Excel 2003 Help, Excel 2010 Help | 0 Comments

Basic Count Average Bar Chart

I have a Workbook with 9 SheetsEach Sheet has 4 columns of data:Column A: Login (Time Stamp of User login)Column B: User (Name)Column C: Team (Department …

March 20, 2018 | Excel 2003 Help | 0 Comments

Delete Duplicates

Ive got data sorted like this (see below), if I select column by column and then go “Delete duplicates” then it works fine, however if I select …

March 19, 2018 | Excel 2003 Help, Excel 2010 Help | 0 Comments

count occurrences of every calendar day within several date ranges

lets say i have : start date 1 and end date 1 , start date 2 and end date 2 , start date 3 and end date 3.    I want to know how many times the date …

November 21, 2017 | Excel 2003 Help, Excel 2010 Help | 0 Comments

Count Multiple Values

Hi, I’m wondering if there is a way to use the Count function while assigning different values to different texts. More specifically, I’m trying to …

October 13, 2017 | Excel 2003 Help, Excel Formulas | 0 Comments

Sum letter and his value

Hi I need some help. I want to put in one column for example 5 times letter X (in two rows) X X X X X X X X X X and I want to have Sum of them (or count) to …

May 20, 2017 | Excel 2003 Help, Excel Formulas | 0 Comments

How to highlight four cells a number of cells away from a reference cell

Hi,  Is it possible to highlight cells a specified number of cells away from a reference cell?  the specified number of cells away would be the value …

April 5, 2017 | Excel 2003 Help, Excel 2010 Help | 0 Comments

Counting within Polygons

I have an excel map two layers. One layer contains points (defined by longitude and latitude) and another layer containing polygons (shapefile format). Is …

February 13, 2017 | Excel 2003 Help, Excel Formulas | 0 Comments

Count With Criteria

Hi, Please how to I count the number of yes in coloumn are the match dog or car in column b? By:

February 1, 2017 | Excel 2003 Help, Formula | 0 Comments

Alternating TRUE & FALSE values – Count

I have a list of data, exported to excel, which has ‘TRUE’ or ‘FALSE’ in a column, based on if they checked a box on a previous form. …

January 30, 2017 | Excel 2003 Help, Formula | 1 Comment

Count color backgrounds

Greetings, I got a question about a function. My skills in VBA isn’t that great, so sorry. But, what I want is a function that will check e.g. cell L5 …

May 6, 2014 | Excel 2003 Help, Excel VBA | 0 Comments

Topic Groupings

AND Array chart Colours in Excel Conditional Formatting count countif COUNTIF Function data Date Dates & Times Excel Excel-Vba Excel 2010 Excel Formula Excel Formulas Excel Functions Excel VBA Code find formula formulas function graph help IF IF Function index list London LOOKUP Macro Macros. match percentage Pivot Pivot Table search SUM Sum Function SumIf SUMIFS table time VBA vlookup

All Time Popular Posts

  • Excel Formula Based on Cell Background Colour 120,433 views
  • How to Concatenate in Excel using LEFT, MID and RIGHT String Functions 85,359 views
  • IF Formula if Time is Greater than 10am 64,046 views
  • Automatically Run Macro when Cell Changes 63,691 views
  • Get File Name with Excel VBA 52,383 views
  • If Functions 52,121 views
  • Add Command Button to an Excel Worksheet 47,924 views
  • Calculate VAT in Excel 43,470 views
  • If Function – If False Do Nothing 38,309 views
  • Excel 2003 Color Scheme when Downloading from SAP 35,425 views

Popular Posts Last Seven Days

  • IF Formula if Time is Greater than 10am 329 views
  • How to Concatenate in Excel using LEFT, MID and RIGHT String Functions 183 views
  • Automatically Run Macro when Cell Changes 181 views
  • Excel Formula Based on Cell Background Colour 145 views
  • Go to Next Blank Row in Excel 121 views
  • Get File Name with Excel VBA 99 views
  • Add Command Button to an Excel Worksheet 64 views
  • copy cell data between sheets based on criteria 62 views
  • How to Check if an Array is Empty in Excel VBA 61 views
  • Enter a Formula to Compute Total Cost 53 views

Pages

  • All Excel Help Posts
  • All Posts
  • Ask a Question
  • Contact
  • Home 8
  • Latest Questions on Excel Geek
  • Post Archive

Categories

  • Excel 2003 Help
  • Excel 2007 Help
  • Excel 2010 Help
  • Excel Formulas
  • Excel Geek
  • Excel VBA
  • Excel VBA Books
  • Favourite
  • Formula
  • Functions
  • Keyboard Shortcut
  • Macros
  • Spreadsheets

Recent Posts

  • Print and page setup
  • VBA to loop through a folder of word documents and populate with data
  • Client Ledger Problem
  • Sheet name reference from dynamic cell
  • Concatenate/IF/SUBSTITUTE/LEN
© 2014 ExcelGeek. All rights reserved.
Optional footer notes.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close