S
Susan Lammi
I need to do a conditional sum on a column of numbers and have two choices
I can see.
the condition is the combination of two other cells (adjacent columns)
I can use Dsum which allows me to examine the two conditions at once or I
have room to create a third column which conjugates the two conditions
( they are text) and use Sumif. In terms of performance which if more
efficient and will run faster.
Your advice is appreciated
I can see.
the condition is the combination of two other cells (adjacent columns)
I can use Dsum which allows me to examine the two conditions at once or I
have room to create a third column which conjugates the two conditions
( they are text) and use Sumif. In terms of performance which if more
efficient and will run faster.
Your advice is appreciated