Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct in VBA
Hello all,
Appreciate your help. Basically, I have a looong equation in an excel cell, mainly utilising Sumproduct function. I.e. (simplified) Cell A4: = sumproduct((D1:D10="June")*(E1:E10="Mark")*(F1:F10 )) Problem is that function above is repeated for multiple entities (i.e. John, Lisa, Nick.... inadidition to Mark) and it gets rather messy. I'm hoping to define a VBA function, such as: getPerson(D1:D10, June, E1:E10, Mark) or getPerson(June, Mark) to make it easy for the person auditing the worksheet (and the second variant so that I don't have to pass the constant references everytime).... Is this possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct Help | Excel Discussion (Misc queries) |