1. M

    VBA SUMIF with changing ranges and criteria based on string

    Hello, I have been trying to put together a code but I do not find the way to do it. I have transactions with an account number (Column A), the values I want to SUM are in column G. Basically, I need to sum all values in column G which Account Number starts with a 004 (e.g. 004101-200 and...
  2. B

    Excel Sumproduct to calculate Amount over Hurdle per person

    Dear All, I'm trying to calculate amount over the criteria, as per range ("L1:M5"). The desired solution in Col O per person. Created Helper Column in Col J but it's limited to one Sales Agent i.e Apple. I was wondering, if the calculation in col J was possible, without a Helper Column in Col...

Some videos you may like

This Week's Hot Topics