Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to populate master spreadsheet from others based on headers | Excel Discussion (Misc queries) | |||
Using a current spreadsheet to populate a new one | Excel Discussion (Misc queries) | |||
How do you populate one spreadsheet from multiple worksheets in a. | Excel Worksheet Functions | |||
Populate a spreadsheet with multiple entries from a master | Excel Discussion (Misc queries) | |||
Can I use a spreadsheet to populate an offline calender in excel? | Excel Discussion (Misc queries) |