Forum Discussion
Count IF
I am trying to create a count if or something along those lines that keeps a running total of assigned jobs. The catch is I can't get the formula to ignore hidden rows, when a job is completed I am h...
I transfered the formula over and changed the inputs to suit how I have the sheet set up and it is populating : #N/A
fomula: =SUM(SUBTOTAL(103,OFFSET(D1,ROW(2:100),))*(D2:D92="Curtis"))
It is an array formula, please note when completing.
{=SUM(SUBTOTAL(103,OFFSET(D1,ROW(2:100),))*(D2:D92="Curtis")) }
When you press Ctrl+Shift+Enter, Excel automatically inserts the formula between { } (a pair of opening and closing braces).
Note: If you have a current version of Microsoft 365, then you can simply enter the formula.
Guidelines and examples of array formulas
Download an example workbook with all the array formula examples in this article.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)