“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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