Link to home
Start Free TrialLog in
Avatar of jnikodym
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.
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Rather use a simple IF statement to check if A1 of Double Stage Trailer is True and if it is true then use SumIF instead of SumIfs.

=IF('Double Stage Trailer'!A1=TRUE,SUMIF('Double Stage Trailer'!C:C,"FET",'Double Stage Trailer'!H:H),"")

Open in new window

Oh. Sorry Saurabh! I didn't see your reply. My apologies.
We were on the same track. :)
sktneer,

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. :)
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