Get instant live Excel expert help with a COUNTIF Functions

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

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")

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")

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")

i am new in excel want to know ablut the countifs function

Need Forumla help. Add up values only if a specific model is apparent. Countifs + sum / total number of countifs

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.

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?

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

I have a formula, it is not working (IDK why). Formula is countifs. Please help me with it. It is very easy :D