Worksheet calculating Spare Fixture counts in General Discussion Posted January 7 Is there any solution by now? I had the same problem today. I would like to have a worksheet with all fixture types inside, summarized by instrument type. Then I would like to multiply the sum of each type with their wattage. So for example I have a worksheet with the count in cell A, the instrument typ in cell B and the wattage in cell C. If I multiply cell A and C, I only get the value from cell C. Like Chad said, it seems that in cell A the value is not really the sum of the instrument types but still the "1". Any solutions?