Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUBTOTAL and COUNTIF (or SUMIF) combination
Hi,
I would like to use the COUNTIF (or SUMIF) only for filtered rows. Thus somewhere a SUBTOTAL kind of functionality but for COUNTIF. Is it possible to simulate (maybe with array formulas)? Many thanks in anticipation. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUBTOTAL and COUNTIF (or SUMIF) combination
A1:B1 = column headers
A2:B11 = data Do a "countif" on B2:B11 = "A": =SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B11,ROW(B2:B11)-ROW(B2),0,1)),--(B2:B11="A")) -- Biff Microsoft Excel MVP "DKS" wrote in message ... Hi, I would like to use the COUNTIF (or SUMIF) only for filtered rows. Thus somewhere a SUBTOTAL kind of functionality but for COUNTIF. Is it possible to simulate (maybe with array formulas)? Many thanks in anticipation. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUBTOTAL and COUNTIF (or SUMIF) combination
Hi there,
How about if you wanted to count the blank cells in B2:B11 where A2:A11="cond"? Any suggestions on how to do that? On Wednesday, February 13, 2008 at 4:12:29 PM UTC-6, T. Valko wrote: A1:B1 = column headers A2:B11 = data Do a "countif" on B2:B11 = "A": =SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B11,ROW(B2:B11)-ROW(B2),0,1)),--(B2:B11="A")) -- Biff Microsoft Excel MVP "DKS" wrote in message ... Hi, I would like to use the COUNTIF (or SUMIF) only for filtered rows. Thus somewhere a SUBTOTAL kind of functionality but for COUNTIF. Is it possible to simulate (maybe with array formulas)? Many thanks in anticipation. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUBTOTAL and COUNTIF (or SUMIF) combination
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal and sumif help | Excel Discussion (Misc queries) | |||
subtotal and sumif | Excel Worksheet Functions | |||
Subtotal on SumIf | Excel Worksheet Functions | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
SUMIF - HLOOKUP Combination | Excel Worksheet Functions |