| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CONDITIONAL SUBTOTALS
How can u calculate a conditional subtotal?
Some array formula like: {=SUBTOTAL(3,(IF((A1:A5=1)*(B1:B5="a"),C1:C5)))} In other words, to count elements within C1:C5, only if any of the respective cels in A1:A5 reflect 1 and B1:B5 has "a"? Thanx -- Best Regards, FARAZ A. QURESHI |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals & Conditional Formatting Part 2 | Excel Worksheet Functions | |||
| Subtotals and Conditional Formatting | Excel Worksheet Functions | |||
| Conditional subtotals | Excel Worksheet Functions | |||
| Conditional Formatting and Subtotals | Excel Discussion (Misc queries) | |||
| How do I use conditional formatting to change subtotals row format | Excel Worksheet Functions | |||
Threaded Mode
