enter image description here

I want to write a formula to count the Total Cost cell in column F, only if the cell in H is checked. I've approached it a few ways, but the Countifs formula isn't computing it.


Try filter(), like this:

=sum( iferror( filter(F2:F, H2:H) ) )

The formula assumes that the data table spans the range A1:H.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.