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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top