sumproduct vba

  1. E

    Create a sumproduct function in vba

    Hello, I need to make a sumproduct_if function in vba, but I really don´t know how to start. This is what I have: Function SUMAPRODUCTO_SI(rango_1 As Range, rango_2 As Range, rango_cond As Range, condicion As String) As Double Dim filauno As Integer, columnauno As Integer, filasuno As...
  2. F

    SumProduct result as Text Box value in VBA

    Hi everyone, I'm new to this forum and this is my first post. I have a worksheet where I use this function =SUMPRODUCT(--(MONTH('2014'!C1:XFD1)=MONTH(C1)),--(YEAR('2014'!C1:XFD1)=YEAR(C1))+0,'2014'!C25:XFD25) to calculate the total sales volume in a given month and year. I want the result of...
  3. T

    Sumproduct VBA

    Hi all, I'm a VBA newbie, using Excel 2010. I'm working on a macro and need to place sumproduct in a series of cells. I have a set of data that has been created with the header row starting on row 4. The sumproduct formula will first be entered into cell X3. I need to sumproduct all of the...
  4. R

    Use VBA to identify multiple activities on a Day.

    I need to find a way using VBA to identify multiple activites on a particular day. Example: Monday ------------Morning Session with Adam Adam Monday ------------Lunch with Adam Adam Monday ------------Afternoon Session with Adam Adam. These...
  5. E

    SUMPRODUCT working in worksheet but not in VBA

    I have this formula on sheet SUMPRODUCT(--(MONTH(Venda!$L$3:$L$5000)=MONTH($A9)); --(YEAR(Venda!$L$3:$L$5000)=YEAR($A9)); Venda!M3:M5000), it´s works fine but I have to translate to VBA code. I have been tried Sheets("Venda").Select Range("A3").Select Lastcl = Cells(Rows.Count...

Watch MrExcel Video

This Week's Hot Topics

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