Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have created the below spreadsheet to track outstanding bills for clients.

Sample spreadsheet

I am trying to create a formula that will sum all the clients who have "No" for the value in the Paid column so I can know exactly what is outstanding at any given moment. I'm certain this can be done, but how?

share|improve this question
up vote 3 down vote accepted

Assuming you want to sum the totals (column B) when Paid="No" (column F), the formula you would use in J3 for "Total Outstanding Bills" is

=SUMIF(F2:F13,"No",B2:B13)
share|improve this answer
    
I believe you need the = operator before NO =SUMIF(F2:F13,"=No",B2:B13) – Brad Patton Mar 8 '13 at 2:02
    
@BradPatton I tested this before I posted it, it worked fine as is. – Dan Mar 8 '13 at 17:48

Use named ranges. Select B column and name it Total. Then select F column and name it Paid. Then the formula you are looking for would be =SUMIF(Paid,"=No",Total)

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .