Hello,
I have a DSUM formula in my spreadsheet that looks like this - =DSUM(Sheet1!$A:$L, Sheet3!$I1, Sheet3!$A1:$J2). A1 to J2 in Sheet 3 is a set of fields with corresponding values that the function tests against.
Now my issue is I need to exclude certain names from the sum. I worked around by including another column in B1 that excludes all names with 'AL' in them. This is not scalable as I'm forced to create a column for each combination that needs to be excluded.
How do I exclude values in the Dsum function?
Thanks.
I have a DSUM formula in my spreadsheet that looks like this - =DSUM(Sheet1!$A:$L, Sheet3!$I1, Sheet3!$A1:$J2). A1 to J2 in Sheet 3 is a set of fields with corresponding values that the function tests against.
Code:
Name Name Status Ops Grade Score Amount Date Sum Description
<>*AL* FAC BUDGET 1/1/2012Now my issue is I need to exclude certain names from the sum. I worked around by including another column in B1 that excludes all names with 'AL' in them. This is not scalable as I'm forced to create a column for each combination that needs to be excluded.
How do I exclude values in the Dsum function?
Thanks.