super

Hi, I have a query related to SUMPRODUCT with multiple criteria in Rows and Columns. Using the below example to explain the problem. I have data of sales figures of various products belonging to different categories for different quarters over a few years. Am trying to calculate the...

HI all so this is a pretty straight forward and simple question (i think) and please excuse my stupidity if it's something super obvious but.... how is this super simple formula a circular reference??? =SUMIF(N:O,N9,O:O) I get this message after i copy this formula down (say about 10 rows...

I am trying to solve an engineering problem using matrices. I know some programming in VBA but not alot, this problem has puzzled me for quite a while. So any idea will be much appreciated. Each of [4 x 4] matrix is generated based on the parameters of the equation, but for the purpose of easy...

Need to calculate number of boxes. Need to add "TM" in another row and highlight in yellow and another blank row. Total the qty. 5 In Big Box 3 or 4 in Medium Box 1 or 2 in small box TM names vary from 1 to 15 Here is the example Any formula to do this <tbody> TM Address City State Zip...

I've been looking for some time for code to perform the simple operation of flipping numbers back and forth between positive and negative. As an accountant I've tried many, many versions. Some work quickly, but balk when it interacts with text - error #Value . Others are super slow as it...

Any idea what I can do to speed this up it goes super fast when i run it from telnet. When i use SQL to pull into excel this report takes super long. Here's the code. The question marks are using the client number in excel and a date like today()-1460 formula, because I don't know how to write...