sumproduc

  1. R

    Sumproduct in a Pivot Table?

    Hello, I have a pivot table that shows me the return of few financial aplications ("ÍNDICE 1" and "ÍNDICE 2"), to do this I had to set this both collumn as a "sum" and changed the format to %. Everthing is ok... the problem is that I can´t sum this values on the total of the table/group, I...
  2. R

    Counting January dates with sumproduct from cells populated with if statement “” evaluates #value!

    Excel 2007. I have a workbook with three main sections that share information. 1. Project sheets. These have random sheet names and contain project information. In cell S16 I am calculating a start date based on project type and status. I am checking to see if cell 108 is filled in to...
    • rbrace
    • Thread
    • date if statement quotation sumproduc value error
    • Replies: 7
    • Forum: Excel Questions
  3. K

    Help with SUMIFS function transpose to 2003 Product

    I have the following function in an 2010 spreadsheet and need to use it on several work stations with 2003. Unfortunately the boss said no go on upgrading Office. I know a SUMPRODUCT or combination SUM and IF will work, just having trouble getting the correct transpose. Please help. Thanks...

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