sumif and if

  1. D

    Formula to add 1 for previous day

    Hello, I have a list of Machines on each Friday that I would like to flag with a number. The latest Friday should have a 2 and each Friday before that should be marked with one less than the last. My data is below. <colgroup><col width="90" style="width: 68pt; mso-width-source: userset...
  2. H

    Need customized Sumif formula

    Hi Excel Experts, I need to customise the Sumif formula here...if you look at the below table..typical sumif will give the require numbers however, I should get the sumif results at once not at every line where we have same lines....for example below <colgroup><col...
  3. E

    Possibly SUMIF-function related

    Hello, I am trying to sum up a column with some budget-numbers, and if there has been a revised budget, use that cell instead of the original. Basically two colums: A - Budget B - Revised 1 3 2 3 1 4 Is it...
  4. O

    Formula Help - Using IF & SUMIF

    Task I have a commission report for my team - I've managed to get the formule correct to total each person by booking agent BUT, I need to have a check/balance......IF THE RANGE DOES NOT INCLUDE THEIR BKAGENT INFO - SUM IT So, for each employee, its BZ70XX - where XX is their individual...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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