Does anyone know how to calculate a total of say cell (i11:i40) but only if a cell in that same row says paid? Basically i have all of my jobs for my company in google sheets and the total profit is adding up and giving me a total in cell i10. I only want that total in i10 to be the total of all the jobs paid and not to include the unpaid. So i need to subtract that unpaid amount if a certain cell says unpaid. Thanks and sorry if this doesn't make sense lol

1 Answer 1


Suppose your range that may hold a value of "paid" is J11:J40.

In I10, use this formula:


Of course, you'll need to replace J11:J40 with the actual range from your sheet that may hold a value of "paid."

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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