How do I use countif formula across sheets?
I provided simplified file with short example so if anyone can help it will be appreciated.
Cross COUNT.xlsx
I need to count how many times number 5 appears in, for example, A2 cells, and how many times number 4 appears in, for example, A3 cells across multiple sheets. Also if, for example, there is no data at all in all corresponding cells (for example, Sheet1A2,Sheet2A2,Sheet3A2,Sheet4A2 and Sheet5A2) formula should return zero in Sheet6A2.
Bookmarks