Hi, I have a formula
=COUNTIF('M:\999 Governance\Error Handling\[error handling issues data Jen new version.xlsx]Master sheet'!$Q:$Q,"<=1")
which counts all the instances where a number in column Q is less than or equal to 1. This works fine. However I am trying to create a dashboard on a different workbook to the one where the data is so I know this formula won't work as countif does not work across workbooks unless both are open which defeats the object of having the dashboard.
I know sumproduct is the answer and I am convinced I have made it work in this way before but for the life of me I cannot make it work now!
I would also need to vary the formula so it would do the same but this time where the number was between two values such as 2 and 5
Please put me out of my misery as I know this can be done!
Bookmarks