criterion

  1. G

    AVERAGEIF - single criterion in multiple columns?

    I recently became familiar with the "AVERAGEIF" function. I've gotten the hand of using it, but now I have a problem. I am working with records that can have up to five separate category codes. Thus, 5 columns are reserved for the category of a given record. To create a column average for a...
    • Gsaraco
    • Thread
    • average averageif averageifs criteria criterion
    • Replies: 9
    • Forum: Excel Questions
  2. D

    count unique occurences with two criteria

    Hi I'm trying to count unique occurences of a column when two other columns meet the criteria. The formula i'm trying to get to work is below but I keep getting a #N/A. Can anyone help? =SUM(IF(FREQUENCY(IF(RED_Delivery_Query!$I$2:$I$2200<>"",IF(RED_Delivery_Query!$D$2:$D$2200=$C4...
  3. G

    SolverAdd not adding a criterion.

    The code below is part of a macro that programmatically sets criteria in Solver and runs Solver. The process has appeared to have worked perfectly for multiple machines and versions of Excel for about a year. I am using Excel 2003. However, I have come across an error that I cannot fathom. When...

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