| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do anyone know how to implement the function?
I use function "=SUMPRODUCT((Sheet2!A2:A10="Food")*(Sheet2!C2:C10 ))" to get the total cost in sheet1. Do anyone know how to implement the following function: When I click the cell with value of $42.00 in the total cost column of Shee1. The corresponding rows with "Food" type in Sheet2 will be highlighted or retrieved out. Thanks a lot!!! ------------------ Sheet1 ID TYPE TOTAL COST 1 Food $42.00 2 Drink $18.90 3 Movie $21.10 4 Music $64.99 ------------------------ Sheet2 TYPE DETAIL COST Drink Coke $3.50 Movie DVD Rent $9.10 Movie Tickets $12.00 Food Seafood $25.00 Drink Wine $15.40 Music Tickets $55.00 Food Hamburg $5.00 Food Cheese $12.00 Music CD $9.99 -- minrufeng ------------------------------------------------------------------------ minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208 View this thread: http://www.excelforum.com/showthread...hreadid=395172 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use a function to implement a naming convention? | Excel Worksheet Functions | |||
| how to implement xbrl | Excel Discussion (Misc queries) | |||
| Better Way To Implement Indirect IF Function? | Excel Discussion (Misc queries) | |||
| Implement CSE function through VBA with parameters | Excel Worksheet Functions | |||
| How to implement an iRtdServer? | Excel Programming | |||
![minrufeng[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
