Seeking Your Help

[Ikram Siddiqui]

Hi Expert,

Please note that I am preparing a report for management to show a comparison between years, i.e., status same period last year.

I stuck by using the below status in my formula.......

Container report is a source file, column-H is Brand, column I is status, E, is column Year and column O stock received date.....
B-is start date, from the date result sheet
C-is end date, from the date result sheet.

=COUNTIFS('Container Report'!$H$9:$H$2082,Report!$B20,'Container Report'!$I$9:$I$2082,$C$19,'Container Report'!$E$9:$E$2082,$A$18)*('Container Report'!$O$9:$O$2082>=$B$18)*('Container Report'!$O$9:$O$2082<=$C$18)

Can you please help me with it?

 

[Hany ali]

How to Help You Without Excel File As Example ?!!!

 

[Ikram Siddiqui]

I sincerely thank you for your response.

and I do apologize for not providing an excel sheet for necessary verification.

Kindly find attached as you needed.

BR ~ Ikram Siddiqui

 

[vletm]

Ikram Siddiqui
Could You explain - how do Your given Title aids future searches ... as written in Forum Rules?

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Use Relevant words in the Title and in the tag Box, This will aid future searches.