Get instant live Excel expert help with COUNT Function

I am trying to develop a spreadsheet to be used for an athletics competition that will do a couple of thinks, firstly it will rank an athletes individual performance in as race or field event, secondly it will calculate a team (club) score depending on the position the athlete comes. Only the first two athletes from each club count

Hello, I have data of different respondents all belonging to different departments (HR, Finance, IT, Sales), and I want to count how many people have agreed/ strongly agreed to a number of questions ONLY if they belong to say HR, if have used the formula below, however, it doesn't seem to work, are you able to help me find out why? =IF(CP3:CP20="HR",COUNTIFS(C3:E20,"Strongly agree",C3:E20,"Agree"),"")

i need some help to display percentages and count at the same time in graphs

I need help with an IF statement in Excel. I work for a youth hockey organization and I have the scores of the recent games. A win of more than 5 goals or a loss of more than 5 goals is called a 'blowout' game. How can I write a formula to say if a value in a cell is >5 or <5, return the value of 1 so that I can simply count the number of 'blowout' games?

need to use vlookup to list 3 posts based on count() in excel which shows which posts have the most comments

I need assistance creating mix of a pivot table and a formula to sort the data I need for that table. You'll see in the file a tab called "Master Pool". This is where all the data will be extracted from. The most important data is column A - Header "Accnum" (this is the data that we'll count in any pivot tables), column O (Header-"Item Type"), and columns V,W,X, and Y (Headers Accessibility (1-4). The resulting report I need has to show the data points in V,W,X, and Y by the data in the column "Item Type". This is the issue I'm having: The data in columns V,W,X, and Y for each accnum is presented in different order, often separated only by a comma. On the tab "A11Y Tag" you'll see all the available options that can go in each one of these fields. The header on those tabs matches the headers on the "master pool" tab. The issue is extracting that data for each item in a way that doesn't show overlaps (i.e.- the same data can be in multiple columns), extracting it in a way that ignores the commas and lack of spaces, and the resulting report will be easy to read. The resulting report must also show a percentage breakdown of items with accessibility data/ and those without. This info is easy to get, it's in column T ("Metadata Present?") on the tab "Mast Pool".

how can I extract a unique count of contest entries from a list?

HI I have attached a chart i want to find a way to count the total numbers in the coloured cells in column K . can i do countif using colours of cell? the cells colour might change in the right for example if one is now red and changed to yellow i would like the number to be updated in the yellow how can i do that?

Task Please combine both data sets into one tab, bring ‘multi color’s and ‘Goal Completions All’ to the Data Source 1 and add a pivot table to map keywords to URLs. Values for each URL should be: Count of ‘keywords’

I am trying to use the COUNTIF equation in excel. However, I do not want to count the value in another cell, in the same row, if the values are equal to each other. Can you help?