jnikodym
asked on
Excel Sumifs with a cell that is linked to a checkbox
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.
=SUMIFS('Double Stage Trailer'!H:H,'Double Stage Trailer'!C:C,"FET",'Double
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oh. Sorry Saurabh! I didn't see your reply. My apologies.
We were on the same track. :)
We were on the same track. :)
sktneer,
It's okay happens all the time... :-)
Saurabh...
It's okay happens all the time... :-)
Saurabh...
It happens when you open the question, think about the solution, create a solution and post it without refreshing the page to make sure someone else might have posted the same solution before you.
Maybe a casual attitude. :)
Maybe a casual attitude. :)
The solution above works perfectly, but here is just a slightly different variations. (Just FYI)
='Double Stage Trailer'!A1 * (SUMIF('Double Stage Trailer'!C:C,"FET",'Double Stage Trailer'!H:H)
Open in new window