I have a spreadsheet with dates in row 1 across the top that errors occurred at a number of cash registers, with the register numbers listed down Column A. Below each date is an “X” for each register that had an error that day. I need to keep track of how many errors occurred on each register in the last 90 days, so want to count the nonblank cells in each row for the columns for only the last 90 days, based on the TODAY()-90 value. Playing with COUNTA, COUNTIF, COUNTIFS functions, but can’t figure out how to test the date in Row 1 while using one of the various COUNT functions in each register row below to count the nonblank X cells. I can see the simple way would be to replace the X’s with the date and use CountIF, but I’m curious how to do the first option with the X’s.
Thanks
Steve