-
Cross sheet reference - count with multiple parameters
Hello all, I'm looking for advice to write a cross-sheet reference formula. I have two sheets: one list of all students who have completed internships, and a second sheet with a list of organizations where our students have interned. I'd like to pull in a count of how many students interned at a particular site in a…
-
COUNTIFS within a date range
I have a large worksheet with assignments over the course of months for multiple people. Some assignments are for more than one person. I have built a formula that works for tracking assignments using the COUNTIF logic. =COUNTIF({Written Budget - 2025 Offseason (2/17-8/31 Range 1}, HAS(@cell, Creator@row)) I'm now trying…
-
COUNTIF Formula Returns Zero in Sheet Summary
I have a very simple COUNTIF formula that isn't working in the sheet summary section. For example, I'm trying to count how many times the year "2017" appears in a column called "Tablet Year". The formula should be: =COUNTIF([Tablet Year]:[Tablet Year], 2017) I've also tried surrounding the "2017" in quotation marks in case…
-
Distinct and Countifs even possible?
I am trying to find the number of induvial emails who submitted a form each week, each month, and each year. I have a form where users add in their own email and anyone who was involved in filling it out. I want to count the number of unique emails listed during different time frames. I tried to use =COUNTIFS([Contact…
-
Count Report
Hello, I have a sheet with 7 columns each indicating a different team or step in our process (UX, Content, Regulatory Review, Planning, Execution, Data, Testing). I also have around 300 rows of tasks that need to hit each team/step. All cells in the sheet begin at "Not Started" As they move through each team, the team…
-
Count checked boxes in a column from another sheet
Hi All, I am working on a dashboard that displays various info and tasks in state of completion. I'm wanting to count how may checkboxes in a column to display a chart in my dashbord showing % complete. Based on other posts I felt it was a good idea to create a helper sheet that has the formulas and reference into the main…
-
Get a Countif on values in a multi-select column of cells
I am trying to write summary formulas to determine how many values appear of each in the drop-down of a column. I tried adding a wildcard, I have tried HAS, and tried CONTAIN, but I'm still not getting the right values. Currently I am getting 0 as a return value on this formula: =COUNTIF([ROI Type]:[ROI Type], HAS([ROI…
-
Countifs formula not returning a value.
Challenge: Countifs formula is not returning a value from a cross sheet. Any help would be so greatly appreciated. Summary: I am trying to pull in counts for a specific month and status for an application. The formula doesn't state any errors but it doesn't return the values. Formula: =COUNTIFS($Name18, {Status}, [JAN…
-
Formula for a Countif in the last year
I am working on pulling historical data from another source sheet but I only want to evaluate the data within the last year. I am having problems with getting the formula to pull information. I am attempting to count completed projects that were ordered in this calendar year. The idea would be to take this concept and use…
-
Countifs + Distinct + Contains
Looking for some help folks if anyone has any ideas I have a grid of marketing content by market, some of which are the same content in different languages. I want to count the content types by market but only unique content, i.e. I dont want to count the same piece of content in all languages. I've tried this -…