Dsum Help


Joined
Apr 18, 2012
Messages
1
Reaction score
0
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.
Code:
Name	Name	Status	Ops	Grade	Score	Amount	Date	Sum	Description
	<>*AL*	FAC				BUDGET	1/1/2012

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top