Get instant live Excel expert help with COUNT Function
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need column J through O to count the # of instances of a certain product in column H.
Solved by F. F. in 23 mins
how to i right a function that will count the number of rows in each column with a specific identifier in another? in the sheet uploaded i was to count the number of rows (or cells filled) in each column from "list view" that have the same value in column a. I know i can just do (counta(value_range) but I don't want to go through and manually type that in for each identifier.
Solved by I. J. in 19 mins
I have a very large list of data on individual members. This data includes each person's Federal District, City, and State.
I want to count the number of people who live in each Federal District, City, and State.
Attached is a very small version of that list. I have already used Advanced Filtering to create a list of every unique Federal District, City, and State.
I am trying to figure out the Excel formula to count all the entries. It is easy to count individual entries from one row (i.e., all cities), but that is not helpful because some city names are duplicated in other states.
Solved by O. B. in 17 mins
In the loading sheet,
The calendar sheet is used as a reference to start the calculations in the "count down" sheet
My formula lookup up a reference values and then adds the corresponding "countdown sheet" values.
Row 3 works perfect because it in in the match is found in the first column, column.
Row 4 finds its match in the second column, because of indexing I loose I set of data, the total row values should add up the values in column "B"
Rows 4,5,6 etc each loose an additional column
can u please help
Solved by K. S. in 24 mins
I have used the countonbgcolor script to count the background color as:
function countOnBGColor(range, colorref) {
var sheet = SpreadsheetApp.getActiveSheet();
var color = sheet.getRange(colorref)
.getBackground();
var range = sheet.getRange(range);
var rangeVal = range.getValues();
var count = 0;
var allColors = range.getBackgrounds();
for (var i = 0; i < allColors.length; i++) {
for (var j = 0; j < allColors[0].length; j++) {
if (allColors[i][j] == color) count += 1;
};
};
return count;
}
This works great but it does not update when the the sheet is updated. Is there a way to get the script to function automatically to update the value in change with the background color, even reloading the page doesn't update it. The only way I can get it to update is to change it then change it back. PFA Link.
Solved by K. L. in 29 mins
In the Shop loading sheet, I lookup the calendar sheet and where it finds a match ( Q???? numbers) , I want the formals to lookup the count down sheet and match the respective hours, but I only want the. when the formula finds a match.
When it finds a match I want it to always start in the first match column and thereafter index.
Solved by Z. F. in 12 mins
I'm trying to record a macro that will create a pivot table. I want the pivot table to display the "division" field name in both the row and values section of the pivot table so that it outputs the number of teams in each division.
For example:
Advanced: 15
Intermediate: 20
Beginner: 5
After I record the macro and try to run it I get the error message -
Run-time error '1004': Method 'CreatePivotTable' of object 'PivotCache' failed
This is what the VBA looks like:
Sub Macro1()
'
' Macro1 Macro
'
'
Sheets.Add
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"2017-USA-Spikeball-East-Tour--P!R1C1:R51C40", Version:=xlPivotTableVersion14 _
).CreatePivotTable TableDestination:="Sheet1!R3C1", TableName:= _
"PivotTable1", DefaultVersion:=xlPivotTableVersion14
Sheets("Sheet1").Select
Cells(3, 1).Select
With ActiveSheet.PivotTables("PivotTable1").PivotFields("division")
.Orientation = xlRowField
.Position = 1
End With
ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables( _
"PivotTable1").PivotFields("division"), "Count of division", xlCount
End Sub
Solved by V. A. in 22 mins
Column G has an x if a job was completed and is blank if the job is not completed. I want to get a percentage of jobs completed versus jobs that are not completed. However, I only want it to count a blank in Column G as a job if there is a name of a client in column A.
Solved by M. E. in 13 mins
I have a sheet that I'm trying to get a working formula to count the number of instances of dates within a range.
Solved by D. S. in 13 mins
Hello,
We're counting parent comments from a school district survey.
We're coding each comment with the school site abbreviation, ( Jones Elementary School = JES ) and then either an A (Affirmation), C(Concern), or N(Neutral).
I understand how to get totals for the district by just using COUNTIF "A" etc., but what I'd like to do is get a count by school. If the comment is from JES, count/total A, C, N, or if the comment is from BES do not count)
Any suggestions would be greatly appreciated.
(Attached is a sample of what I'm hoping to do.)
Solved by M. D. in 29 mins