Q: Each subject you want to highlight will need 2 front lights positioned to their left and right in front of them and angled about 45 degrees down at them. This is the standard 3-point lighting technique that most shows use. This lighting system eliminates dark shadows while providing 3D definition to the form of the subject. This is the third light in the standard 3-point system. Place the light directly behind the subject and angled down about 45 degrees at them. You can experiment with the lighting to create different effects if you want something less conventional. For example, single-point lighting, with just 1 front light, can be used to mimic the effect of the sun and create dramatic shadows. 2-point lighting, with just 1 front light and 1 back light, can be used as well. Divide the stage into zones that are approximately 8ft (2.4m) in diameter. You will need to cover each zone with a light fixture to create general lighting that illuminates the whole stage. For example, if your stage is 25ft (7.6m) by 25ft (7.6m), then you would divide it into 9 8ft (2.4m) zones and cover each with a different lighting fixture to create the general illumination for the stage. You will still need additional lights to light up backgrounds, scenery, or highlight other things not covered by the area lighting. Make sure to include the location of any fixed lighting bars that you plan to use to hang lights in the diagram. Be specific about what lights go where, where they will point, what colour they will be, and any other relevant info. If you have the facilities, you can add more fixed bars or use stands on the floor to add extra lights. If your venue doesn't have enough lights, look into companies that can rent you additional lights. Dimmer racks give you the ability to fade the lights in and out fluidly using a lighting desk or console. You will need training on how to use the lighting desk or console if you do not have any experience doing so. You can also set up a DMX controller after you have hung your lights if they are DMX compatible. A DMX controller allows you to preprogram light settings and effects that you can easily transition between with a single slider on the lighting console. Plug the lights in via a DMX cable and program the light scenes that you want so you can quickly create different scenes during the performance. Remember to double check the position and angles of all your lights before each performance, in case something got accidentally moved. You don't want to realize a light isn't working properly in the middle of the performance!
A: Angle front lights at 45-degree angles to the left and right of their subject. Angle a back light at a 45-degree angle directly behind the subject. Divide the stage into a grid and cover with overlapping lights to create a wash. Draw a diagram of the stage and where you will put the lights. Hang your lights and plug them in to a dimmer rack.

Q: Since SUMIF can interpret non-numeric data, your data tables will need to be set up a little differently from a basic + or SUM function. Create one column with number values and a second column with a conditional value, like "yes" and "no". For example, a column with 4 rows with values 1-4 and a second column with alternating values of "yes" or "no". Select a cell and enter "=SUMIF" then enclose the conditions in parentheses. First you must enter a range, then criteria, then a second range to summate. In this case, the criteria the yes/no condition, the range will be the cells containing those criteria, and the summation range is the target values. For example: =SUMIF(C1:C4, yes, B1:B4). This means the column C, which contains the yes/no condition, will add any values from column B where column C reads "yes". The cell range will vary depending upon your data table.
A:
Set up your data for a SUMIF function. Enter the function into a cell.