countifs error

[ajnabidst]

Dear all,

I am facing error with the attached file. Kindly assist me on that.

Am trying to count all sheet (sheet 1 to sheet 3), the dates and in relation to date and position and get result.

For so cell its working and some not. Correct me where i am going wrong.

Thank you in advance.

Regards,

 

[AliGW]

Wrong syntax! What you have done will only return results that match across the sheets. You need to take each sheet separately:

=COUNTIFS('6.12.2019'!C:C,$A4,'6.12.2019'!D:D,$C$3)+COUNTIFS('7.12.2019'!C:C,$A4,'7.12.2019'!D:D,$C$3)+COUNTIFS('8.12.2019'!C:C,$A4,'8.12.2019'!D:D,$C$3)

 

[ajnabidst]

Wrong syntax! What you have done will only return results that match across the sheets. You need to take each sheet separately:

=COUNTIFS('6.12.2019'!C:C,$A4,'6.12.2019'!D:D,$C$3)+COUNTIFS('7.12.2019'!C:C,$A4,'7.12.2019'!D:D,$C$3)+COUNTIFS('8.12.2019'!C:C,$A4,'8.12.2019'!D:D,$C$3)

really thank you for the timely help.

 

[AliGW]

Glad to have helped.