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
F35 only when
A35 show paralegal1. What I need this formula to do is add bonus from cells
F35 only when cells
A35 show paralegal1 and also cells
E35 show data.
So how can I modify the formula to do what I want?