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 an Excel sheet that keeps track of bonus for our paralegals. Because we need the clients to be listed in one sheet all the paralegals are also in one sheet instead of each having their own. I need the Excel sheet to add the amount of the bonus for each paralegal individually for which I have the formula:


Now I need to edit this formula so that it takes into account another cell but only when that cell contains data. If that cell does not contain data then I don't want it to add the bonus.

So for example this formula adds the bonus on cells F2 to F35 only when A2 to A35 show paralegal1. What I need this formula to do is add bonus from cells F2-F35 only when cells A2-A35 show paralegal1 and also cells E2-E35 show data.

So how can I modify the formula to do what I want?

share|improve this question

if you're using excel 2007 and up, use:


if you're using 2003 and below, use:


share|improve this answer

You must log in to answer this question.