sumfis

  1. C

    SUMIF - Based On Unique Values and Multiple Criteria

    Good evening all, I was wondering if someone would be kind enough to help mewith the following please? What I am trying to achieve is the following: Retrieve the gross balance for all accounts (excludingduplicates where there is >1 of the same entry / account) in Column A whilstalso...
  2. A

    Making sumifs les heavy to calculate or using other way

    Hello, I am using sumifs to manange a large amount of data that have additional rows every time, so I am using the whole column to capture all data even if I am in row 200,000. It works great but it recalculates and takes seconds to update. Is there a better way to do what I need to do so it...
  3. R

    Problem with Sumifs and Multiple Criteria

    Hello, I currently have a workbook where I have two tabs. The second tab is a copy/paste from an export where the columns will remain the same though the length may differ. I have the following formula that works great for getting the hours an employee worked on a certain project. =SUMIF('ADP...

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