good day
i wish to count how many times a specific value occur on a specific date across different sheets. i am attaching a sample workbook.
Book1_sample.xlsx
in the workbook, the dates are extracted from the various sheets and added in cells C3:L3 (or as many dates there are)
B4:B are constants that will remain there and the values that needs to be found and counted
the values being counted are always in column F in the different sheets.
either code or a formula would work, pivot tables not ideal.
your assistance is highly appreciated
regards
Bookmarks