I'm creating a COUNTIFS formula that tabulates matched occurrences for basic criteria in a range of cells (let's call the range of cells A2:A200) but want to use other cells as references for the basic criteria.
So my formula might look like this: =COUNTIFS(A$2:A$200,">1",A$2:A$200,"<2") meaning that it should tabulate anything greater than 1 and less than 2.
When I try to use a cell reference for 1 and 2 (let's call it B1 for 1 and B2 for 2) and then use those cells in the formula instead of the actual numerals, I get an error.
Following the way that the formula above is laid out, I've tried the formula this way: =COUNTIFS(A$2:A$200,">B1",A$2:A$200,"<B2")
Is there a proper syntax to allow the use of cells instead of values in the criteria portion of a COUNTIFS formula?
Thanks!
Bookmarks