Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help
Hi everyone! I am setting up a monthly personal budget in Excel, and I wanted to set the spreadsheet to automatically pull totals from my checkbook (in another Excel file) based on categories. In other words, my budget would have a section for "gasoline" and the formula would search my checkbook for "gasoline" items and then pull the totals from that category over to the budget automatically. Does this make sense at all? If so, let me know if there is a possible way to do this. -- hogiejax ------------------------------------------------------------------------ hogiejax's Profile: http://www.excelforum.com/member.php...o&userid=35071 View this thread: http://www.excelforum.com/showthread...hreadid=548161 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help
If your descriptions are in Sheet1 A1:A6, and amounts in Sheet1 B1:B6, try:
=SUMPRODUCT(--(ISNUMBER(SEARCH("gasoline",[Checkbook.xls]Sheet1!A1:A6,1))),[Checkbook.xls]Sheet1!B1:B6) Change source workbook, worksheet, and range references as needed. Sumproduct cannot accomodate an entire column (A:A, A1:A65536) "hogiejax" wrote: Hi everyone! I am setting up a monthly personal budget in Excel, and I wanted to set the spreadsheet to automatically pull totals from my checkbook (in another Excel file) based on categories. In other words, my budget would have a section for "gasoline" and the formula would search my checkbook for "gasoline" items and then pull the totals from that category over to the budget automatically. Does this make sense at all? If so, let me know if there is a possible way to do this. -- hogiejax ------------------------------------------------------------------------ hogiejax's Profile: http://www.excelforum.com/member.php...o&userid=35071 View this thread: http://www.excelforum.com/showthread...hreadid=548161 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |