I'm struggling to use numbers to do a function. Specifically, I want to use COUNTIF to check two things within my data set table and put that information into another table that we'll call "query set". I want to check for one variable that is within the first column of the query set is the same as the first colum in the data set and that the value is the same as the query set's first header.
I just don't know how to do that because using
COUNTIF("Raw::January::1st:31st", $A2) works for making sure that one query condition. I guess the question is how do I filter COUNTIF so that it uses the second query as a check as well? I kinda want to do something like this, want it to only
COUNTIF(January::$A:$AE,$A2, January::$A:$AE,"$January::$A:$AE = B$1").
You can take a look at the spreadsheet here ...
So what I want to do is check that the value of the cell is equal to $A2, and that the header of that cell is the day of the week I'm looking for as well.