| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toggle values with SUMPRODUCT
Looks like we have a winner!!! Thanks Bob.
Alan "Bob Phillips" wrote: Put the name in a cell, say A1, and use =SUMPRODUCT(--(Region=E$11),--(Group=$D17),INDIRECT(A1)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alan Smith" wrote in message ... Hi to all, I am trying to build a basic Balance Sheet to use as a reference for another project. One worksheet contains all the data for each month of 2006 (monthly ending balances), and I am using the following to pull it into my template: =SUMPRODUCT(--(Region=E$11),--(Group=$D17),January) Where Region is the region the office is in, Group is the account group the balance belongs to (Cash, A/R etc.) and January is the month to show (all ranges are named). Is there a way I can setup some form of toggle for the month , so I can switch between each of the 12 months, and not have to change formulae or create duplicate worksheets? All help appreciated. Regards, Alan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average only first number of actual values | Excel Worksheet Functions | |||
| How to Search, Count, Match and Post Values | Excel Worksheet Functions | |||
| URGENT: Please Advise. SumProduct and Operand Question | Excel Discussion (Misc queries) | |||
| Obtaining Max and Min Values with Sumproduct | Excel Discussion (Misc queries) | |||
| Toggle switch between absolute and relative values creating a macr | Excel Discussion (Misc queries) | |||
Hybrid Mode
