=sumif

  1. Z

    =sumif?

    Add numbers up in column C that don't have the word (equp rental) name in column D. I was thinking =sumif <> equp rental, DD I don't know
  2. Small Paul

    =SUMIF in VBA

    Hi I am sure this is very simple but having tried a variety of options from other threads I cannot solve it. I am trying to add a simple =sumif formula to a macro: Range("H35").Select .FormulaR1C1 = "=sumif(H4:H32,<=0)" I have tried without the R1C1 as well but the error 'invalid or...
  3. T

    Rolling 12 Mo. by date.

    Hello, I am throwing in the towel and asking for help... I have been trying to find a formula that will track the sum for a range of cells and exclude any rows in which the date is more than one year old. Here is the data (I mocked up a visual aid using a table below): Dates will be entered in...
  4. M

    Maintain values in a =sumif( formula

    I am trying to keep my sumif formula values from changing. I have macros set up to input different numbers or rows into a spreadsheet and a =sumif formula to find a value and add them together. THe probme i'm having is that my current formula (=SUMIF($C$1:$C$100,"value",$K$1:$K$100)) keeps...
  5. S

    The most efficient way to SUM() a series of substrings

    If in column R I have a 6 digit numeric string in each cell like below what would be the most efficient way to calculate the total of the first two digits, then the 2nd two, then the 3rd two, other than using a lengthy formulae for each cell like these =LEFT(R1,1) + MID(R1,2,1) =MID(R1,3,1) +...
  6. L

    =Countif Question

    Hi, I've searched though and have not found the answer that is working for me on this question. I have a range of number in column F. The Values range from -24,000 to +5,000. I would like to use the countif formula to find how many numbers are between the value of 0 to +500. I have lots of...

Watch MrExcel Video

This Week's Hot Topics

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
Top