Formula to count rows in a date range across columns and status
I am getting suck trying to create a =COUNTIF formula from a sheet that has my date column, and several other qualifying status columns.Any advise would be greatly appreciated. Here is where I am at so far and I am getting an #INVALID Data Type error.
In this argument, I want to count all the rows in the last 30 days that have a status of anything other than "Complete" in column range 7.
Help Article Resources
Check out the Formula Handbook template!