Dmx Stage Lighting
Tuesday, August 31st, 2010Dmx Stage Lighting
 |
No items matching your keywords were found.
Excel formula help?
Trying to do a spreadsheet for cable needed for lighting a stage.
APS
APS2K
DMX
S400
APS
DMX
I need the formula to add all APS cable, all DMX cable and so on and still allow me to keep each type of cable in random order on the spreadsheet. Tried the =dvarp...not sure how to formulate this.
Thanks
Do you mean you have various cables of certain lengths, and you need to add up how many feet of APS, how many feet of DMX ... and still keep them in the same order on the sheet?
I'm assuming that you have them arranged geographically by which lights they go to and don't want to lose that information.
First, create a range that contains just the cells with lengths - let's call it "cable_length". Then create another range with the cells with the cable type: call it "cable_type"
Use the SUMIF function ...
Syntax: SUMIF(range; criteria; sum_range)
SUMIF(cable_type; "ABX"; cable_length") should get you how many feet o ABX you have. Repeat the formula for each type of cable. You can do this at the side of the data columns.
Range is the range to which the criteria are to be applied. (the cable type you are looking for)
Sum_range is the range from which values are summed.
*********
PS: One way to maintain an order is to add a column called "sort order" and fill it from 1 to whatever ... then you can sort on anything else and restore the original order by sorting on the "sort order" column.
Republished by Blog Post Promoter
