Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull data based on month
Hi
I have a large database like below. I need to pull data based on catagory, subject and date. Example would be looking for catagory1, subject2 data for jan and get 29 or subject1 data for feb and get 7.I set up as database and pull info for year using this formula =DSUM(Database,C$79,$B$99:$D$100) but can not get month to work Date Subject1 subject2 subject3 1-Jan 10 15 20 2-Jan 6 14 3 "" "" 1-Feb 7 5 3 Thanks Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pull data from multiple sheets based on input | Excel Worksheet Functions | |||
Excel pull data based upon one specific word between two date | Excel Worksheet Functions | |||
Pull in a colum of financial data based on the month | Excel Worksheet Functions | |||
Get Data based on Month and Year | Excel Worksheet Functions | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) |