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.
=COUNTIFS({Sheet1 Range 3}, AND(@cell <= TODAY(), @cell > TODAY(-30), {Sheet1 Range 7}, <>"Complete"))
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.