=sumifaa

  1. B

    sumif for all numbers starting with a couple digits

    I want to get the sum of all numbers in col b when the ID in col a starts with 14. So for example <tbody> 14012 50 15000 1 14999 100 16045 3 </tbody> =SUMIF(a:a,"14*",b:b) I'm getting a zero. My formula seems to work for text in col A but not for numbers. Help please!
  2. M

    SUMIF returns 0 when comparing a date

    Hi, This might be a stupid question but I'm not an expert (yet) in Excel formulas. I have used the following formula: =SUMIF(A:A,A:A<TODAY(),B:B) In my column A, I have only dates and in my column B numbers. I tried a simple IF to compare A with TODAY() and this works perfectly. I have also...

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