Forum Discussion
Formula Help
I have a workbook that produces 2 percentages when data is feed into it from another workbook. In this workbook I type in a specific cell the name of the workbook which includes a date. When I open t...
How do I use the countif function ignoring hidden cells in excel?
abdulhman_al_bogami you should really start a new thread as this question doesn't have to do with this thread. In answer, I don't think you can. You should use COUNTIFS and add all the conditions you need to filter down to only what you want
Carl_61 If you have the original source files like UnitAvailabilityDetails02_07_2023 where each is dated and the dates are predictable (i.e. every monday) then you might be able to have a formula in each cell that would 'point' to a corresponding filename and skip the monday report file that will have values changing each time. You would probably want to use INDIRECT or a macro to make entering all those formulas easier.
Carl_61 If you have the original source files like UnitAvailabilityDetails02_07_2023 where each is dated and the dates are predictable (i.e. every monday) then you might be able to have a formula in each cell that would 'point' to a corresponding filename and skip the monday report file that will have values changing each time. You would probably want to use INDIRECT or a macro to make entering all those formulas easier.