View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rev rev is offline
external usenet poster
 
Posts: 1
Default 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?