Populate a spreadsheet from a data set
 

I have a data set from access that I exported into Excel. Now I am trying to
write a formula that will summarize the data based 3 criterias
(appropriation, business org, and expenditure code. So, I want to summarize
all salary data (expenditure code ccs) for appropriation 101, and business
org 11. I have tried an array formula, but I haven't got it to work? Any
suggestions?

Populate a spreadsheet from a data set
 

Pivot Table would do that for you.
Appropriation on your rows, Business org on columns and expenditures in your
data.

If you really don't want to have pivots, Copy and paste special values
elsewhere to ensure all appropriations and biz orgs are captured in rows and
columns as needed, then make a sumproduct:

Assuming columns in the order listed below:
=sumproduct(--(DataSheet!$A$2:$A$5000=$A2),--(DataSheet!$B$2:$B$5000=B$1),(DataSheet!$C$2:$C$50 00=$A2))

where A2 is your first appropriation, B1 is your first biz org.

HTH!


"rev" wrote:

I have a data set from access that I exported into Excel. Now I am trying to
write a formula that will summarize the data based 3 criterias
(appropriation, business org, and expenditure code. So, I want to summarize
all salary data (expenditure code ccs) for appropriation 101, and business
org 11. I have tried an array formula, but I haven't got it to work? Any
suggestions?