-
How to count values if either of two conditions are true
I have two sheets: Sheet A and Sheet B I would like to count the number of cells in Sheet A, Column A and Sheet B, Column B that have the value "Liver". Both sheets are stored under the same folder.
-
Sheet Reference Formula for Last Week?
I have a source sheet set up that has three columns: State, Delivery Date and =WEEKNUMBER from the Delivery Date formula. I have a metric sheet set up where I want to use a =COUNTIF formula to calculate rows from the source sheet with deliveries by state, and I want it to count by delivery date from the previous week (not…
-
CONTAINS to count cells with specific string of numbers
Is there a way to use COUNTIFS and CONTAINS to count cells that include a specific string of numbers as well as cells that include that string plus something else? In the example below, I'm trying to count the number of students who are taking the course with the Code "20659," which should include those taking only that…
-
Countifs where sheet range is formula returning a number and criterion is sheet summary dynamic drop
I have a column called '"Wave" which shows a number 1-10. The value is returned on some rows from a =PARENT formula and on some rows it's hardcoded. (I understand it should be either formula or hardcoded but go with me here...) I have a sheet summary which works perfectly well when the 'Wave' column in my sheet is…
-
Status and Date Formula
Hello, I have been out of the game for a bit and having trouble writing this formula. Trying to collect monthly data for completed calls. Currently I have my formula written as this: =COUNTIFS({Status}, ="Complete", {Initial Call}, AND(IFERROR(MONTH(@cell, 0)) = 1)) Getting the incorrect Argument error. Can't figure out…
-
Using CountIfs with an and condition summarizing data from sheet 1 to sheet 2
I have a sheet that list PC that has been deployed to a user at a given location The detail sheet has the suer location and a checkbox for when the PC has been deployed. On a summary sheet, I am tracking for each location, how many deployments were planned and how many have been completed. I am trying to use CountIfs abut…
-
Count IFs or Sum IFS Formula
Hello all!! So currently trying to get a sheet summary formula to show the number of Dealer ID's that are not enrolled. Pretty much just need the number of Dealer ID's shown on the SS when the Enrolled Checkbox Column is not checked. There should be 162 Dealer ID's that are not checked but the formula I am using is…
-
Help with formula
I am setting up as simple tracking of an annual communications plan and have a Platform of Engagement column with about 12 drop down platforms to select from. I want a formula to track the amount of engagement on each platform selected within this column. The following formula works counting for one platform of engagement,…
-
COUNTIFs for multiselect drop downs
Hello, I have a set of form responses where 350 colleagues have given their job level, and provided their 5 personal goals (in separate columns), and which of our organisational targets their goal aligns to. They have selected the alignment to our organisational targets from a multiselect dropdown, and some people's goals…
-
Sheet Formula
Happy 2024 everyone, I hope your year is off to a great start! I'm back requesting help to get some formulas working. I am trying to use the countif formula to count a column in a sheet. I am trying to get it to count all the dates in the column, but I also want to use to the formula to count all the rows with that same…
