Get instant live Excel expert help with a COUNTIF Functions
“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 have this formula set up ...=IF(COUNTIF(AW24:AW26,1)>0,1,0)
so anytime a 1 is in the data range, it shows up as 1. i want to modify the formula to whenever a 1 or greater shows up
Solved by G. B. in 22 mins
In cell B12, add an AVERAGEIF function that will find the average call length for the Dept named range and the criteria specified in cell A12 and in cell C12, add a COUNTIF function that will count the number of calls for the Dept named range and the criteria specified in cell A12.
Solved by G. C. in 23 mins
trying to break down a list by values using countif, also trying to use countif to separate non-numerical values ( i.e. car makes), is that possible? also how do I take those result and break them from a list of 120 values into their own columns? thanks
Solved by Z. J. in 12 mins
Need help with a google sheet formula. Trying to use countifs with multiple text criteria and a different cell that do not equal zero.
Solved by S. J. in 18 mins
I have three different sheets within one Google Sheet. One of those sheets contains a column of dates. I want to use countifs excel. The date must be greater than or equal to a cell on another sheet, and a cell next to them must match text from another sheet. I am attempting to use a countifs formula, however, I am not having any luck.
Solved by K. L. in 12 mins
Hello.
I've searched everything I can find on countifs, array formula, named ranges and cell references and I can't find out why my formula isn't working.
This formula is working:
=SUMPRODUCT(COUNTIFS(E7:F7,{1,2},E12:F12,"X"))
I would like the array {1,2} to be pulled from a cell reference or a named range instead of having it embedded in the formula. So I tried these:
=SUMPRODUCT(COUNTIFS(E7:F7,B11,E12:F12,"X")) where B11 contains {1,2}
And
=SUMPRODUCT(COUNTIFS(E7:F7,Weeks,E12:F12,"X")) where Weeks is a named range referencing B11
I use CSE after entering each of these to get the curly brackets.
Yet neither pull back the correct results (they show a 0 when the correct formula (the first one) would pull back 2.
Solved by M. B. in 16 mins
I'm trying to figure out how to use a countifs function that filters by all or some of the names in the dropdown menu listed in cell B4 on the "Filtered Pipe" tab.
Solved by O. F. in 23 mins
require assistance on using countifs and counta forumula, unable to dervie.
Solved by D. J. in 25 mins
I need to find out a complex countifs formula - will use a spreadsheet
Solved by C. J. in 25 mins
Hello - interested in how to assign a unique ID to duplicate countifs results
Solved by D. U. in 30 mins