super

  1. T

    SUMPRODUCT with multiple criteria in Rows and Columns (Still function as SUMPRODUCT instead of SUM or COUNT)

    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...
  2. deletedalien

    How is this a circular reference????

    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...
  3. T

    Matrix addition of overlapped quadrant

    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...
  4. S

    Calculating Number of Boxes

    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...
  5. C

    Flip sign in VBA for hotkey - keep formatting, skip non-numeric values

    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...
  6. D

    SQL Going really slow but code works any tips?

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top