# 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