subtotal sumif

  1. E

    Formula to add up a subtotal of a filter range between two date

    Hi I need to sum up the sales in the range R56:R5044 I have a daily date range N56:N5044 and 2 date criteria in Q5 & Q6 which are using the following dates: 01-02-2019 01-03-2019. I have a Sumif which is working (=SUMIFS(R$56:R$5044,$N$56:$N$5044,">="&$Q5,$N$56:$N$5044,"<"&$Q6)) However I...
  2. E

    staff timesheet

    Hi. I am designing a new staff rota and need to calculate hours and minutes from a selection of dates for the whole year. When I use the formula =SUMIF(F3:F563,">0")/60 this does exactly what want for the whole but I cannot work out how to show a subtotal when I filter the list to show a range...
  3. M

    Power Pivot: Make sum's of General Ledger accounts

    Hi, I need to make a pivot of a general ledger. My problem is that since the amounts are stored on the G/L account entry's and amounts for subtotals like "Total sales" or "Total assets" are sum's that do not have their own accounts I get blank values for these "sum-accounts". I have tried to...
  4. Q

    Subtotal with Sumproduct and Criteria

    Looking to calculate a weighted average if there is a rate in column B, and then to be able to filter on other columns and have the subtotal update with the correct weighted average rate. Below is a copy of the formula I have thus far, where column B lists the rates and column A lists the...
  5. R

    Exclude Subtotal Amounts from a sumif formula.

    I have negative and positive numbers (hours) that I want to sum from several categories on my spread sheet. Each category has a subtotal. I want to sum both positive and negative hours in one column (start to finish) without including the subtotals. Any help would be much appreciated...

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