I am trying to use a sumifs formula and one of my criteria is if cell A1 is true. Cell A1 changes from false to true when a checkbox in the sheet is checked. So my formula looks like this:
=SUMIFS('Double Stage Trailer'!H:H,'Double Stage Trailer'!C:C,"FET",'Double Stage Trailer'!A1,"TRUE")
So, i am trying to sum the values in column H. My first criteria is column C must contain the text FET. I want my second criteria to be if cell A1 has the text TRUE.
I get a #VALUE! in my formula result.