| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Subtotal with data table
Hi, guys,
I am using data tables in Excel 2010 for Windows. I have this formula: =SUBTOTAL(102,Table2[Key]) I want the subtotal to be conditioned on whether the key value is greater than 16000000 (or more humanly readable, 16,000,000). Thanks for the ideas. /s |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional SUBTOTAL in XL210 Table | Excel Discussion (Misc queries) | |||
| Subtotal based on a range of data in Pivot Table | Excel Worksheet Functions | |||
| Subtotal pivot table data to show % split | Excel Discussion (Misc queries) | |||
| Conditional Subtotal in table | Excel Discussion (Misc queries) | |||
| Pivot Table: showing data as % of subtotal | Excel Discussion (Misc queries) | |||
![Sarah H.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
