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...
ccombs765 Look into the AGGREGATE function. You can count values or texts in visible cells in an array through =AGGREGATE(2,5,array)
The 2 means it's using COUNT (3 would be COUNTA) and the 5 means it will ignore hidden rows.