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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

can I compare 2 separate xls columns with differing total number of rows of mailing addresses using fuzzy logic MATCH ("*") and COUNTIF to tally the number of duplicates?
Solved by A. A. in 14 mins
I am creating a new list of students per teacher for an advisory program. I have the list of students per teacher. I am trying to match teachers with students that they see in their classes. I think a CountIF will work...
Solved by E. C. in 13 mins
Why can I not get this formula to copy down the column with the cell references change to match =SUM(COUNTIF(INDIRECT({"K18","S18","AA18","AI18","AQ18","AY18"}),"X"))
Solved by X. E. in 22 mins
I have a countif formula that works just fine. Then I realized I needed a sumif formula to include the quantities. This works: =IF(COUNTIFS(SalesRaw!AA:AA,$X$1,SalesRaw!AB:AB,V4,SalesRaw!AC:AC,W4)=0,"",COUNTIFS(SalesRaw!AA:AA,$X$1,SalesRaw!AB:AB,V4,SalesRaw!AC:AC,W4)) This doesn't: =SUMIFS(SalesRaw!N3,SalesRaw!AA:AA,PriceListRaw!$X$1,SalesRaw!AB:AB,PriceListRaw!V3,SalesRaw!AC:AC,PriceListRaw!W3) can you explain why?
Solved by D. Q. in 28 mins
I need assistance completing the following: 2. Continuing with the “Database” worksheet, follow the steps below: * Use the VLOOKUP formula to populate industry descriptions into the field “INDUSTRY DESC.” Industry codes and descriptions can be found in the “Database Glossary” tab. * PASTE SPECIAL the values in the “INDUSTRY DESC.” field back over the cells (to overwrite the formulas). * Use the COUNTIF formula (to the right of the table) to count the cells in column “I” where the error “value not available” occurred. (Tip: in the “criteria” field, make it “=#N/A”)
Solved by G. H. in 15 mins
Trying to do a countif but be able to have the count change to only .5 if data is entered into adjacent cell
Solved by I. H. in 14 mins
is there a way to combine a sumif and a countif function together: =SUMIF('Store Data'!BM:BN,"*"&B21&"*",'Store Data'!BL:BL(COUNTIF('Store Data'!BQ:BQ,"Yes"))) Currently the above formula returns the answer #REF
Solved by S. H. in 16 mins
I'm trying to countif a range of cells contains the value of cell a1
Solved by K. B. in 20 mins
Hello, I'm trying to lookup data within a date range. It's kind of like a VLOOKUP and kind of like a COUNTIF but I can't get either to work in this scenario. Can anyone help? I can provide an example.
Solved by Z. Q. in 13 mins
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?
Solved by E. C. in 25 mins