Rgb Spot Light

US Auctions Australian Auctions Austrian Auctions Belgian Auctions Canadian Auctions French Auctions German Auctions Indian Auctions Irish Auctions Italian Auctions Dutch Auctions Polish Auctions Spanish Auctions Swiss Auctions UK Auctions

Best Match Time: ending soonest Time: newly listed Price: lowest first Price: highest first Price + Shipping: lowest first Price + Shipping: highest first

Canon EOS 7D Camera Body 70 200mm 28 L IS II NEW    US $3,479.90

Nikon Digital D5000 SLR Camera Kit with AF S 18 55mm VR    US $727.88

Sigma 15 30mm EX IF f35 45mm For Sigma SLR Cameras    US $199.00

Canon EOS 7D Camera Body 85mm 12 L Lens Brand New    US $3,189.90

Canon EOS 5D Mark II EF 16 35mm f 28L II USM Kit    US $3,819.95

Canon EOS 5D Mark II w 100 400mm f 45 56L IS USM Kit    US $3,889.95

Canon EOS 5D Mark II EF 50mm f 12L USM AF Kit 50 mm    US $3,759.95

Canon EOS 5D Mark II EF 85mm f 12L II USM AF 85 mm    US $4,189.95

Canon EOS 5D Mark II w EF 70 200mm f 28L IS USM II Kit    US $4,519.95

Canon EOS 1D IV Canon 85mm 12 Lens    US $6,388.95

Canon EOS 1D IV 70 200mm 28 L IS II    US $6,679.95

Nikon D90 DSLR Camera with 18 105mm 70 300mm Lens    US $1,689.99

Pentax 55 300mm 2X 110 600 Lens kit Pentax KX K200D    US $399.99

Pentax SMC 100mm 28 Macro Lens Kit Ring Light KX K200    US $699.99

NEW PANASONIC Leica 14 50mm L RS014050 L RS014050E GF1    US $849.90

Powered by phpBay Pro

Republished by Blog Post Promoter

Dmx Stage Lighting

US Auctions Australian Auctions Austrian Auctions Belgian Auctions Canadian Auctions French Auctions German Auctions Indian Auctions Irish Auctions Italian Auctions Dutch Auctions Polish Auctions Spanish Auctions Swiss Auctions UK Auctions

Best Match Time: ending soonest Time: newly listed Price: lowest first Price: highest first Price + Shipping: lowest first Price + Shipping: highest first

No items matching your keywords were found.

Excel formula help?

Trying to do a spreadsheet for cable needed for lighting a stage.

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