DSUM with exclusion

[Noobachu]

Hey everyone,

I'm trying to use DSUM with some strange criteria. I have data where each row contains a number and also a number of labels: location, year, component, sector, category, and subcategory. I want to use DSUM to produce the summed expenditures of everything labeled "CDD" in Component that isn't labeled "PICD" in Subcategory. How would I do this? The subcategories are so numerous that it doesn't make sense to use inclusion on the rest besides this.

Thanks,

A Noob

 

[Yahya]

if the amount of expenditures in col G try this

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	location	year	component	sector	category	subcategory	expenditures			component	subcategory
2			CDD			PICD	100			CDD	<>PICD
3			CDD				50
4						PICD	150				50
Sheet1

Excel 2010

Cell Formulas
Range	Formula
K4	=DSUM(A1:G4,G1,J1:K2)