# 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

Hi I need help on this formula. =(COUNTIFS(INDIRECT("'"&SL\$6&"'!J:J"),"B2",INDIRECT("'"&\$SL6&"'!\$L:\$L"),\$C7)) it counts multiple things from different sheets, all I want is to please loock up in the sheet reference, my reference starts from SL6, while same formula I have to past in every 15th cell but say SL6 is first sheet or day, my second formula will be pasted on AY6. but I need reference to go to SM6 not TA6, please help
Solved by O. Y. in 18 mins
need help.... SUM(COUNTIFS('Parts NC Entry'!\$E\$2:\$E\$1934,M9,'Parts NC Entry'!\$K\$2:\$K\$1934,"X")+COUNTIF('Parts NC Entry'!\$E\$2:\$E\$1934,N9,'Parts NC Entry'!\$K\$2:\$K\$1934,"X"))-COUNTIFS('Parts NC Entry'!\$E\$2:\$E\$1934,M9,'Parts NC Entry'!\$G\$2:\$G\$1934,"TRIAL/SETUP",'Parts NC Entry'!\$E\$2:\$E\$1934,M9,'Parts NC Entry'!\$K\$2:\$K\$1934,"X")-COUNTIFS('Parts NC Entry'!\$E\$2:\$E\$1934,N9,'Parts NC Entry'!\$G\$2:\$G\$1934,"TRIAL/SETUP",'Parts NC Entry'!\$E\$2:\$E\$1934,N9,'Parts NC Entry'!\$K\$2:\$K\$1934,"X")
Solved by V. U. in 28 mins
need help =SUM(COUNTIFS('Parts NC Entry'!\$E\$2:\$E\$1934,M9,'Parts NC Entry'!\$K\$2:\$K\$1934,"X")+COUNTIFS('Parts NC Entry'!\$E\$2:\$E\$1934,N9,'Parts NC Entry'!\$K\$2:\$K\$1934,"X"))-COUNTIFS('Parts NC Entry'!\$E\$2:\$E\$1934,M9,'Parts NC Entry'!\$G\$2:\$G\$1934,"TRIAL/SETUP",'Parts NC Entry'!\$E\$2:\$E\$1934,M9,'Parts NC Entry'!\$K\$2:\$K\$1934,"X")-COUNTIFS('Parts NC Entry'!\$E\$2:\$E\$1934,N9,'Parts NC Entry'!\$G\$2:\$G\$1934,"TRIAL/SETUP",'Parts NC Entry'!\$E\$2:\$E\$1934,N9,'Parts NC Entry'!\$K\$2:\$K\$1934,"X")
Solved by K. F. in 29 mins
need help SUM(COUNTIFS('Parts NC Entry'!\$E\$2:\$E\$1934,M9,'Parts NC Entry'!\$K\$2:\$K\$1934,"X")+COUNTIFS('Parts NC Entry'!\$E\$2:\$E\$1934,N9,'Parts NC Entry'!\$K\$2:\$K\$1934,"X"))-COUNTIFS('Parts NC Entry'!\$E\$2:\$E\$1934,M9,'Parts NC Entry'!\$G\$2:\$G\$1934,"TRIAL/SETUP",'Parts NC Entry'!\$E\$2:\$E\$1934,M9,'Parts NC Entry'!\$K\$2:\$K\$1934,"X")-COUNTIFS('Parts NC Entry'!\$E\$2:\$E\$1934,N9,'Parts NC Entry'!\$G\$2:\$G\$1934,"TRIAL/SETUP",'Parts NC Entry'!\$E\$2:\$E\$1934,N9,'Parts NC Entry'!\$K\$2:\$K\$1934,"X")
Solved by O. E. in 25 mins
i am new in excel want to know ablut the countifs function
Solved by F. A. in 26 mins
Need Forumla help. Add up values only if a specific model is apparent. Countifs + sum / total number of countifs
Solved by G. Y. in 16 mins
I'm stuck on the Countifs part. I think my array may be compromised. This is the starter workbook. I can send what I'm on.
Solved by D. H. in 15 mins
On sheet 2, I am trying to count how many people were terminated between 1/1/16 and 1/31/16. I used a countifs formula with criteria to match the job title, not be blank, >= to 1/1/16, <= to 1/31/16. It is not counting anything. What am I doing wrong?
Solved by D. B. in 29 mins
COUNTIFS('Follow Up For Product'!K:K,"Paid",'Follow Up For Product'!I:I,"="&"") Just I get formula from your expert why it working my excel I just alter some dates
Solved by M. J. in 17 mins
I have a formula, it is not working (IDK why). Formula is countifs. Please help me with it. It is very easy :D
Solved by X. H. in 16 mins